Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Дата
Msg-id AANLkTimzhZr2ZjAQFRP100nrEM=1xqHN=xOa13OYC25=@mail.gmail.com
обсуждение исходный текст
Ответ на Regression: 8.3 2 seconds -> 8.4 100+ seconds  (Francisco Reyes <lists@stringsutils.com>)
Список pgsql-performance
Дерево обсуждения 
Hello

>
> The 8.4 machines have more memory than the 8.3.7 and are in general much
> better machines.
> 8.4 settings
> Shared_buffers 18GB
> effective_cache_size 18GB
>
> Machines have 72GB of RAM
> Tried turning off sequential scan on the 8.4.5 and that did not help.
>
> Any ideas/suggestions?
>

increase statistics on columns. The estimation is totally out.

Regards

Pavel Stehule

> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Следующее
От: Divakar Singh
Дата:
Сообщение: Re: Postgres insert performance and storage requirement compared to Oracle