[rt-users] performance improvements when retrieving a ticket

[Vivek Khera]

>>>>> "NPC" == Nicolae P Costescu <nick at strongholdtech.com> writes:

NPC> We vacuum it nightly, and it does seem all the fields he queries on are 
NPC> indexed already.

One more thing to try after a vacuum full is to reindex all the
indices.  At the psql prompt when connected to the rt2 database, type
"\di" to list them, then run "reindex index XXX" for each one listed.

When you have a lot of churn in your database the indexes tend to
grow.  This is being worked on for the next release of PG, I hear.