[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.

Do you vacuum analyze or just vacuum?

Have you ever run a "vaccum full" to clear out old data?

Did you tune postgres from the defaults?  The defaults are pretty
damned lame for anything but toy DBs.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/