Bug 2135782 - [Backport to 4.12] [GSS] Listing object takes long time
Summary: [Backport to 4.12] [GSS] Listing object takes long time
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat OpenShift Data Foundation
Classification: Red Hat Storage
Component: Multi-Cloud Object Gateway
Version: 4.10
Hardware: x86_64
OS: Linux
high
high
Target Milestone: ---
: ODF 4.12.0
Assignee: Nobody
QA Contact: Parikshith
URL:
Whiteboard:
Depends On:
Blocks: 2141555
TreeView+ depends on / blocked
 
Reported: 2022-10-18 12:13 UTC by Shriya Mulay
Modified: 2023-08-09 16:49 UTC (History)
15 users (show)

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
Clone Of:
: 2141555 (view as bug list)
Environment:
Last Closed: 2023-02-08 14:06:28 UTC
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Github noobaa noobaa-core pull 7099 0 None Merged remove sorting by version_past for Postgres 2022-11-13 09:10:23 UTC
Github noobaa noobaa-core pull 7100 0 None Merged [Backport to 5.12] remove sorting by version_past for postgres 2022-11-13 09:10:24 UTC
Github red-hat-storage ocs-ci pull 6499 0 None Merged Bug 2110504 List large number of objects with prefix and delimeter 2023-02-10 07:50:28 UTC


Note You need to log in before you can comment on or make changes to this bug.