Re: large table starting sequence scan because of default_statistic_target

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Janning Vygen <vygen(at)kicktipp(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: large table starting sequence scan because of default_statistic_target
Date: 2009-03-16 14:40:24
Message-ID: dcc563d10903160740o1e49730dn75805723119fb509@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 16, 2009 at 8:24 AM, Janning Vygen <vygen(at)kicktipp(dot)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(at)kicktipp(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2009-03-16 14:51:41 Re: Imagenes
Previous Message Marcin Stępnicki 2009-03-16 14:30:18 Re: [SQL] Oracle to PostgreSQL