Обсуждение: postgres query is very slow

Поиск
Список
Период
Сортировка

postgres query is very slow

От
donghe@caltech.edu
Дата:
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


Re: postgres query is very slow

От
"Kevin Grittner"
Дата:
<donghe@caltech.edu> 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

Re: postgres query is very slow

От
"Dai, Tino"
Дата:
<donghe@caltech.edu> 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