Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-general by date:

Previous
From: Luis Cevallos
Date:
Subject: Imagenes
Next
From: Marcin Stępnicki
Date:
Subject: Re: [SQL] Oracle to PostgreSQL