Re: default statistics target testing (was: Simple postgresql.conf wizard)

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: default statistics target testing (was: Simple postgresql.conf wizard)
Дата
Msg-id 603c8f070812051111r56dcf0e5hcd505b41c622aab9@mail.gmail.com
обсуждение исходный текст
Ответ на Re: default statistics target testing (was: Simple postgresql.conf wizard)  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Ответы Re: default statistics target testing (was: Simple postgresql.conf wizard)  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-hackers
> On Fri, Dec 5, 2008 at 7:24 PM, Greg Smith <gsmith@gregsmith.com> wrote:
>> comparing to 8.2.9 results:
>> - q1 was 32% slower with dst = 10, 33% slower with dst = 1000
>> - other queries were 19% slower with dst = 10, 25% slower with dst = 1000
>
> You mean that HEAD is slower than 8.2.9 or I don't understand
> correctly what you wrote?

Correct.  As compared with 8.2.9, ANALYZE was substantially faster,
but query planning was significantly slower.

Thanks also to Greg for reposting my emails.  I didn't even realize I
hadn't sent them to the list.

...Robert


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

Предыдущее
От: Martin Pitt
Дата:
Сообщение: Re: Versioned mo file installation
Следующее
От: "Guillaume Smet"
Дата:
Сообщение: Re: default statistics target testing (was: Simple postgresql.conf wizard)