Performance of Search on PostgreSQL Versions 12+
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned | ||
3.10 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Evergreen Version: Any (tested on Evergreen 3.10, but should affect all extant releases)
OpenSRF Version: N/A
Postgresql Version: 12+
Linux Version: N/A
Changes to allow inlining of common table expressions in PostgreSQL version 12 and later have a deleterious effect on Evergreen search: https:/
This was first reported by Chris Sharp in IRC on Dec. 5, 2022: http://
The issue was later confirmed and worked out to have begun with PostgreSQL version 12.
The cause, and a potential solution, were worked out by Mike Rylander and Jason Stephenson in IRC on Friday, Dec 9, 2022: http://
The solution is to prevent two of the common table expressions ("with" queries) used by the Evergreen query parser from being inlined by the optimizer.
I'm setting this confirmed since it was reported by Chris Sharp and verified by myself and others.
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
I assigned this bug to myself while I am looking through the Evergreen code for other places that might require changes for Pg 12+. I believe that I know what to look for as regards the CTEs.