postgres query is very slow
am 22.06.2010 19:23:43 von donghe
Hi,
I built a database on postgres8.1, then I did VACUUM FULL ANALYZE, but th=
e
query is still slow.
Has anybody an idea ?
Thanks
Dong
--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: postgres query is very slow
am 22.06.2010 19:33:15 von 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 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Re: postgres query is very slow
am 30.06.2010 23:03:52 von tdai
wrote:
=20
> I built a database on postgres8.1, then I did VACUUM FULL ANALYZE, but=20
> the query is still slow.
> Has anybody an idea ?
=20
When I had performance problems, what I did was go through the specific=20
queries that we presenting the performance problem and used an analyze on
those queries. I found that there was a significant performance issues=20
with the way that some queries were fashioned. What I ended up doing was
switching to 8.2.
-Tino
--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin