Steve Lane <slane(at)moyergroup(dot)com> writes:
> I have a database that is exhibiting sluggishness under load. Suspecting
> that some queries may be poorly optimized, I turned on a fair amount of
> debugging output in the logs. But I could use some help interpreting it.
I think you're going at this all wrong. EXPLAIN ANALYZE should be the
first tool you turn to, not low-level stats. Browsing the archives of
the pgsql-performance mailing list may help you get started.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: mike g||Date: 2004-05-19 01:33:32|
|Subject: Re: Set Timestamp|
|Previous:||From: Tom Lane||Date: 2004-05-19 00:19:03|
|Subject: Re: "IDENT authentication failed" but I'm not using ident |