[rt-devel] Postgres performance.

Vivek Khera khera at kcilink.com
Wed Apr 2 11:52:44 EST 2003


>>>>> "AM" == Aidan Mountford <aidan at oz.to> writes:

AM> I am having some fairly serious issues relating to the performance of some
AM> of the queries built by the query builder.

Do you have all the recommended indexes built?

Have you run "vacuum analyze" on them to generate the index stats
postgres needs to use them effectively?

Have you ever run vacuum on the tables to keep them of manageable
size?  If not, run a "vacuum full analyze" first, then daily/weekly
run regular "vacuum analyze".



More information about the Rt-devel mailing list