<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 ? 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. -Tino -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
