> -----Original Message-----
> From: Shoaib Burq (VPAC) [mailto:sab@vpac.org]
> Sent: Tuesday, April 26, 2005 9:31 AM
> To: Tom Lane
> Cc: John A Meinel; Russell Smith; Jeff;
> pgsql-performance@postgresql.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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend