Re: Postgresql performance

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Postgresql performance
Дата
Msg-id 1047505552.55840.56.camel@jester
обсуждение исходный текст
Ответ на Postgresql performance  (Enix Empreendimentos e Construções Ltda.<contato@enix.com.br>)
Список pgsql-performance
> Is the performance of the mentioned Postgresql version much slower than the
> 7.3.1?

Somewhat, but not significantly.

Standard questions:

Have you run VACUUM?
Have you run ANALYZE?
What does EXPLAIN ANALYZE <query> output for the slow queries?

If performance is still poor after the first 2, send the results of
EXPLAIN here and we'll tell you which index you're missing ;)

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Вложения

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

Предыдущее
От: "Chad Thompson"
Дата:
Сообщение: Re: Postgresql performance
Следующее
От: Max Baker
Дата:
Сообщение: speeding up COUNT and DISTINCT queries