Re: Tuning, configuration for 7.3.5 on a Sun E4500

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Tuning, configuration for 7.3.5 on a Sun E4500
Дата
Msg-id 200503070931.06241.josh@agliodbs.com
обсуждение исходный текст
Ответ на Tuning, configuration for 7.3.5 on a Sun E4500  (<tsarevich@gmail.com>)
Ответы Re: Tuning, configuration for 7.3.5 on a Sun E4500  (<tsarevich@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Tsarevich,

> When running queries we are experiencing much bigger result times than
> anticipated.
>
> Attached is a copy of our postgresql.conf file and of our the table
> definitions and row counts.

Looks like you haven't run ANALYZE on the database anytime recently.  Try that
and re-run.

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Help trying to tune query that executes 40x slower than in SqlServer
Следующее
От: Hugo Ferreira
Дата:
Сообщение: Re: Help trying to tune query that executes 40x slower than in SqlServer