Observed speed increases through judicious indexing user/miker/better-living-through-indexes-2.4
authorMike Rylander <mrylander@gmail.com>
Thu, 28 Feb 2013 18:28:20 +0000 (13:28 -0500)
committerMike Rylander <mrylander@gmail.com>
Thu, 28 Feb 2013 18:28:20 +0000 (13:28 -0500)
commitac61e1b517e88b74b8c26ad6ffa437d38f58899f
tree6b5236b5cedba5307ba822afb101145141071197
parentf1c1d0b0de3b170cc1cc6ec0b2b1800c9e01177c
Observed speed increases through judicious indexing

These indexes drove high-cost queries down into the noise
at several sites.  They are more applicable for larger
installations, where "larger" can be defined as either "lots
of data in the db" or "has used Evergreen for a long time".

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/005.schema.actors.sql
Open-ILS/src/sql/Pg/040.schema.asset.sql
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/400.schema.action_trigger.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.general-indexing-needs.sql [new file with mode: 0644]