Does anyone have a good reference for Postgres performance tuning. The
first thing I'm looking for is a way to determine my bottle-neck. My
system is currently running with 5-6 processes in the runqueue and 100%
cpu utilization (50% in the kernel). I'm guessing I'm cpu-bound but I'd
like to find out why (I'm doing mostly inserts, but I have a lot of
foreign keys). I know postgres has a lot of pg_stat_* tables but I'd like
to learn how to use these and other performance analysis tools.
Thanks,
Sheer