In the last exciting episode, siracusa(at)mindspring(dot)com (John Siracusa) wrote:
> What column(s) should I increase? Do I have to do anything after increasing
> the statistics, or do I just wait for the stats collector to do its thing?
You have to ANALYZE the table again, to force in new statistics.
And if the index in question is on _just_ the date column, then it is
probably only that date column where the "SET STATISTICS" needs to be
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
Faith is the quality that enables you to eat blackberry jam on a
picnic without looking to see whether the seeds move. -- DeMara Cabrera
In response to
pgsql-performance by date
|Next:||From: Stephan Szabo||Date: 2004-01-05 22:33:17|
|Subject: Re: deferred foreign keys|
|Previous:||From: Christopher Browne||Date: 2004-01-05 20:26:15|
|Subject: Re: Select max(foo) and select count(*) optimization|