> I built a database on postgres8.1, then I did VACUUM FULL ANALYZE, but
> the query is still slow.
> Has anybody an idea ?
When I had performance problems, what I did was go through the specific
queries that we presenting the performance problem and used an analyze on
those queries. I found that there was a significant performance issues
with the way that some queries were fashioned. What I ended up doing was
switching to 8.2.
In response to
pgsql-admin by date
|Next:||From: Joshua D. Drake||Date: 2010-06-30 21:54:03|
|Subject: Re: postgres database user account|
|Previous:||From: Tom Lane||Date: 2010-06-30 20:59:24|
|Subject: Re: cache lookup failed for index |