LP#1846354: Move the deleted filter out of the query for speed collab/phasefx/consolidate_patron_notes_tweaked
authorMike Rylander <mrylander@gmail.com>
Thu, 10 Sep 2020 17:43:03 +0000 (13:43 -0400)
committerJason Etheridge <jason@EquinoxInitiative.org>
Fri, 11 Sep 2020 17:52:08 +0000 (13:52 -0400)
commit43290aed39953adecbfd8835d6ccbb912db7164a
tree59b181d3109d58f29d17fd865344f74c6616c223
parent05f731bc14587b8d600209b6ad975e067afef5a4
LP#1846354: Move the deleted filter out of the query for speed

Also tweak the aump view so that PG can use better plans

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>
Open-ILS/src/perlmods/lib/OpenILS/Application/Actor.pm
Open-ILS/src/sql/Pg/005.schema.actors.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation