Re: large table starting sequence scan because of default_statistic_target

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

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.

Janning

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Stępnicki 2009-03-16 14:30:18 Re: [SQL] Oracle to PostgreSQL
Previous Message Scott Marlowe 2009-03-16 14:13:51 Re: large table starting sequence scan because of default_statistic_target