Re: [ADMIN] postgres query is very slow

2010-06-30 Thread Dai, Tino
wrote: > 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.

Re: [ADMIN] postgres query is very slow

2010-06-22 Thread Kevin Grittner
wrote: > I built a database on postgres8.1, then I did VACUUM FULL ANALYZE, > but the query is still slow. > Has anybody an idea ? I recommend you re-post to the pgsql-performance list, after reading this: http://wiki.postgresql.org/wiki/SlowQueryQuestions The one thing I can say based on

[ADMIN] postgres query is very slow

2010-06-22 Thread donghe
Hi, I built a database on postgres8.1, then I did VACUUM FULL ANALYZE, but the query is still slow. Has anybody an idea ? Thanks Dong -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin