projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e471738) | 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)
committerJane Sandberg <js7389@princeton.edu>
Wed, 22 Feb 2023 15:57:22 +0000 (07:57 -0800)
commit11f098648579930f6eef552866af67b7795dae29
treec39f50a029dd5cb865571898cddc1c5ffdb67bd4tree
parente471738eafa053e4bd618cf4c6a40c55fdc209dccommit | 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>
Signed-off-by: Jane Sandberg <js7389@princeton.edu>
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm diff | blob | history
Evergreen ILS