projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 219f694) | patch
LP#1999274: Improve Search Performance on Pg 12+
authorMike Rylander <mrylander@gmail.com>
Fri, 9 Dec 2022 17:41:43 +0000 (12:41 -0500)
committerJason Stephenson <jstephenson@cwmars.org>
Wed, 22 Feb 2023 14:50:29 +0000 (09:50 -0500)
commit27e8a54e1b017a910bd75980b06f07a9f489abeb
tree9f31a03fd98f2c7011f31a48da8e85d035cd71e2tree
parent219f6943f1da1a329278b47196e6f505ce40da7dcommit | diff
LP#1999274: Improve Search Performance on Pg 12+

Use OFFSET as an optimization fence to keep newer PGs from trying to
fold the c_attr and b_attr CTEs into the main search query.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Jason Stephenson <jason@sigio.com>
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm diff | blob | history
Evergreen ILS