Re: Processor usage/tuning question

On 10/3/14, 2:24 PM, 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.
Are you sure it's the actual postmaster doing that and not just another backend? There's fairly little that the postmaster itself is responsible for, other than spawning new backend connections. If it really is the postmaster, the first thing I'd check is if you've got something that's spamming the database with new connection requests.

--
Jim Nasby, Data Architect, Blue Treble
Data in Trouble? Get it in Treble! http://BlueTreble.com