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