> -----Original Message----- > From: Shoaib Burq (VPAC) [mailto:[EMAIL PROTECTED] > 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