> -----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;
> 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
pgsql-performance by date
|Next:||From: John A Meinel||Date: 2005-04-26 15:05:26|
|Subject: Re: two queries and dual cpu (perplexed)|
|Previous:||From: Shoaib Burq (VPAC)||Date: 2005-04-26 14:31:18|
|Subject: Re: two queries and dual cpu (perplexed) |