Re: postgres query is very slow

Поиск
Список
Период
Сортировка
От Dai, Tino
Тема Re: postgres query is very slow
Дата
Msg-id 1CA7FF980DA3824F9A5C31532B7A40DCDAD46A41@LCXCLMB01.LCDS.LOC.GOV
обсуждение исходный текст
Ответ на Re: postgres query is very slow  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
<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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: cache lookup failed for index
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: postgres database user account