Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x

Поиск
Список
Период
Сортировка
От Douglas J Hunley
Тема Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Дата
Msg-id 200706041305.12740.doug@hunley.homeip.net
обсуждение исходный текст
Ответ на Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x  (Greg Smith <gsmith@gregsmith.com>)
Ответы Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
On Sunday 03 June 2007 18:30:17 Greg Smith wrote:
> To be equivalent to the 7.4 config the 8.2 config would need:

I've taken all the wonderful advise offered thus far, and put the attached
into use. Our initial testing shows a 66% improvement in page load times for
our app. I have the customer beating on things and noting anything that is
still slow.

On a side note, is there any real benefit to using autovacuum over a
periodically scheduled vacuum? I ask because we have the latter already coded
up and cron'd and it seems to keep things fairly optimized.

BTW, I'm on the list, so there's no need to reply direct. I can get the
replies from the list

Thanks again for everyone's assistance thus far. Y'all rock!
--
Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778
http://doug.hunley.homeip.net

I feel like I'm diagonally parked in a parallel universe...

Вложения

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

Предыдущее
От: PFC
Дата:
Сообщение: Re: dbt2 NOTPM numbers
Следующее
От: Thomas Andrews
Дата:
Сообщение: Thousands of tables versus on table?