Postgres Pro
Downloads
Home   >   mailing lists

Re: large table starting sequence scan because of default_statistic_target - Mailing list pgsql-general

From Janning Vygen
Subject Re: large table starting sequence scan because of default_statistic_target
Date
Msg-id 200903161524.09922.vygen@kicktipp.de
Whole thread Raw
In response to Re: large table starting sequence scan because of default_statistic_target  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: large table starting sequence scan because of default_statistic_target  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
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.

Janning

pgsql-general by date:

Previous
From: Marcin Stępnicki
Date:
Subject: Re: [SQL] Oracle to PostgreSQL
Next
From: Scott Marlowe
Date:
Subject: Re: large table starting sequence scan because of default_statistic_target