pgsql(at)mohawksoft(dot)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

In response to

• Query optimizer 8.0.1 (and 8.0) at 2005-02-04 22:10:18 from pgsql

Responses

• Re: Query optimizer 8.0.1 (and 8.0) at 2005-02-04 23:50:30 from pgsql

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