That's an
interesting situation. Your CPU's are pegged, and you're hardly doing any
IO. I wonder if there is some ineficient query, or if its just very high
query volume. Maybe you could try setting log_min_duration_statement to
try to track down the slowest of the queries. Then post the slow queries
with an explain analyze to the list.
Here is some info
on setting up logging:
Are your queries
standard SQL or do you call functions you wrote in PL/pgSQl or PL/Python or
anything? |
Title: Message
- Re: [PERFORM] PostgreSQL performance issues Willo van der Merwe
- Re: [PERFORM] PostgreSQL performance issues Willo van der Merwe
- Re: [PERFORM] PostgreSQL performance issues Dave Cramer
- Re: [PERFORM] PostgreSQL performance issues Willo van der Merwe
- Re: [PERFORM] PostgreSQL performance issu... Dave Dutcher
- Re: [PERFORM] PostgreSQL performance ... Willo van der Merwe
- Re: [PERFORM] PostgreSQL performance issues Merlin Moncure
- Re: [PERFORM] PostgreSQL performance issues Alan Hodgson