Postgres Pro
Downloads
Home   >   mailing lists

Re: Query optimizer 8.0.1 (and 8.0) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Query optimizer 8.0.1 (and 8.0)
Date
Msg-id 17961.1107555455@sss.pgh.pa.us
Whole thread Raw
In response to Query optimizer 8.0.1 (and 8.0)  (pgsql@mohawksoft.com)
Responses Re: Query optimizer 8.0.1 (and 8.0)  (pgsql@mohawksoft.com)
List pgsql-hackers
Tree view 
pgsql@mohawksoft.com writes:
> I suspect that analyze only samples a very small amount of the database
> and gets the wrong idea about it. Is there a way to force analyze to
> sample more  rows?

default_statistics_target.  But let's see the pg_stats rows for these
columns before assuming that analyze is getting it wrong.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Escaping the ARC patent
Next
From: Stephen Frost
Date:
Subject: Re: Query optimizer 8.0.1 (and 8.0)