> We have also done little to no performance tuning of Postgres' > configuration. We do have indexes on all of the important columns and > we have reindexed. Any pointers would be greatly appreciated.
Tuning will often double (if not more) the performance. What are the specs of the box? Memory, CPU, Disk. Are any of these short? Are you swapping? Pegged CPU? iostat reports heavy disk usage? What else is running on it? How often does your data turn over? (Frequency of updates / inserts / deletes) I assume you have vacuumed recently? Please attach output of VACUUM VERBOSE. Please attach your postgresql.conf file. Please include the header lines from 'top' output (memory cache / buffer lines in particular). -- Rod Taylor <rbt [at] rbt [dot] ca> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part