> -----Original Message-----
> From: Shoaib Burq (VPAC) [mailto:sab(at)vpac(dot)org]
> Sent: Tuesday, April 26, 2005 9:31 AM
> To: Tom Lane
> Cc: John A Meinel; Russell Smith; Jeff;
> pgsql-performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] two queries and dual cpu (perplexed)
>
>
> OK ... so just to clearify... (and pardon my ignorance):
>
> I need to increase the value of 'default_statistics_target'
> variable and then run VACUUM ANALYZE, right?
Not necessarily. You can set the statistics for a single
column with ALTER TABLE.
> If so what should I choose for the 'default_statistics_target'?
> [...]
Since you have a decently large table, go for the max setting
which is 1000.
__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East, Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129