Re: large table starting sequence scan because of default_statistic_target

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: large table starting sequence scan because of default_statistic_target
Дата
Msg-id dcc563d10903160740o1e49730dn75805723119fb509@mail.gmail.com
обсуждение исходный текст
Ответ на Re: large table starting sequence scan because of default_statistic_target  (Janning Vygen <vygen@kicktipp.de>)
Список pgsql-general
On Mon, Mar 16, 2009 at 8:24 AM, Janning Vygen <vygen@kicktipp.de> wrote:
> On Monday 16 March 2009 15:13:51 Scott Marlowe wrote:
>> On Mon, Mar 16, 2009 at 7:15 AM, Janning Vygen <vygen@kicktipp.de> wrote:
>> > Hi,
>> >
>> > Why does default_statistic_target defaults to 10?
>> >
>> > I suggest to setting it to 100 by default:
>>
>> Already done in 8.4
>
> GREAT! sorry for not searching the archives or changelog before.

Hey, no problem, there's plenty of new stuff coming up in 8.4, and a
lot of it doesn't show up on the general list anyway.  This just makes
sure a few more people know about this change.

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

Предыдущее
От: Janning Vygen
Дата:
Сообщение: Re: large table starting sequence scan because of default_statistic_target
Следующее
От: Tino Wildenhain
Дата:
Сообщение: Re: Imagenes