<donghe@xxxxxxxxxxx> 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 the information you've provided so far is that you can expect major performance improvements if you upgrade to a new major release of PostgreSQL. Well, there is one other thing -- it's almost never a good idea to run VACUUM FULL. You may have bloated your indexes. You could try a REINDEX on the database. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
