Bug 2135782
| Summary: | [Backport to 4.12] [GSS] Listing object takes long time | |||
|---|---|---|---|---|
| Product: | [Red Hat Storage] Red Hat OpenShift Data Foundation | Reporter: | Shriya Mulay <smulay> | |
| Component: | Multi-Cloud Object Gateway | Assignee: | Nobody <nobody> | |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Parikshith <pbyregow> | |
| Severity: | high | Docs Contact: | ||
| Priority: | high | |||
| Version: | 4.10 | CC: | assingh, bkunal, bzvonar, cgaynor, dmoessne, ealcaniz, eglottma, hnallurv, kramdoss, muagarwa, nbecker, ocs-bugs, odf-bz-bot, pibanezr, tdesala | |
| Target Milestone: | --- | |||
| Target Release: | ODF 4.12.0 | |||
| Hardware: | x86_64 | |||
| OS: | Linux | |||
| Whiteboard: | ||||
| Fixed In Version: | 4.12.0-111 | Doc Type: | Bug Fix | |
| Doc Text: |
Cause:
After some indexes changes, for some list queries, Postgres performs a sort of all object mds
Consequence:
When there is a big number of object mds, the list operation takes a long time and can also timeout on the client side.
Fix:
Changed the related DB queries such that the query will be based on the new indexes and avoid the need to sort the data.
Result:
Db queries are completed in a reasonable time and the list performance is improved
|
Story Points: | --- | |
| Clone Of: | ||||
| : | 2141555 (view as bug list) | Environment: | ||
| Last Closed: | 2023-02-08 14:06:28 UTC | Type: | Bug | |
| Regression: | --- | Mount Type: | --- | |
| Documentation: | --- | CRM: | ||
| Verified Versions: | Category: | --- | ||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
| Cloudforms Team: | --- | Target Upstream Version: | ||
| Embargoed: | ||||
| Bug Depends On: | ||||
| Bug Blocks: | 2141555 | |||