> 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
In response to
pgsql-hackers by date
|Next:||From: Stephen Frost||Date: 2005-02-04 22:23:27|
|Subject: Re: Query optimizer 8.0.1 (and 8.0)|
|Previous:||From: Philip Warner||Date: 2005-02-04 22:14:16|
|Subject: Re: Escaping the ARC patent |