Re: Processor usage/tuning question

On Friday, October 03, 2014 11:24:31 AM Israel Brewster wrote:
> I have a Postgresql 9.3.5 server running on CentOS 6.5. In looking at some
> stats today, I saw that it was handling about 4-5 transactions/second
> (according to the SELECT sum(xact_commit+xact_rollback) FROM
> pg_stat_database; query), and an instance of the postmaster process was
> consistently showing 40%-80% utilization to handle this. I didn't think
> anything of that (the machine has plenty of capacity) until I mentioned it
> to a friend of mine, who said that utilization level seemed high for that
> many transactions. So if that level of utilization IS high, what might I
> need to tune to bring it down to a more reasonable level?
>

You probably have some read queries not properly indexed that are sequentially
scanning that 1.2 million row table over and over again. Enable slow query
logging and see what's going on.