Skip to content

Drop index_projects_on_path_and_id for projects

Leonardo da Rosa requested to merge 428838-drop-projects-on-path-and-id-index into master

What does this MR do and why?

Drops index_projects_on_path_and_id for projects table, as part of Reduce LockManager LWLock Contention (&11543 - closed).

index_projects_on_path_and_id" btree (path, id) is covered by index_projects_api_path_id_desc" btree (path, id DESC)

Check #428838 (comment 1666021886)

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #428838 (closed)

Edited by Leonardo da Rosa

Merge request reports