Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

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 по дате отправления: