Re: PostgreSQL performance issues - Mailing list pgsql-performance

From Willo van der Merwe
Subject Re: PostgreSQL performance issues
Date
Msg-id 44F5A559.9050701@studentvillage.co.za
Whole thread Raw
In response to Re: PostgreSQL performance issues  ("Dave Dutcher" <dave@tridecap.com>)
List pgsql-performance
Dave Dutcher wrote:
> 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:
> http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html
>
> Are your queries standard SQL or do you call functions you wrote in
> PL/pgSQl or PL/Python or anything?
>
>
It might be a combo of queries and load. My queries use almost
exclusively functions, but on an unloaded dev machine performs its
queries in aprox 10ms. When is it appropriate to start clustering
database servers?

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: Re: performance problems.
Next
From: "Merlin Moncure"
Date:
Subject: Re: PostgreSQL performance issues