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:56:03 +0000 (07:56 -0800)
commitaa30c7e7b23a6dc4f10f5f1e7382cba13d787cf5
treed6e2c3e0a568a54c67fdd33aa9c912736d743d96
parent39c44d2c0a6f5eab4d93b564b079be1cf75d85f2
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