Re: Is there any way to force analyze to run on a whole table?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is there any way to force analyze to run on a whole table?
Date: 2003-09-29 23:54:32
Message-ID: 13455.1064879672@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> Is there any way to force analyze to run on a whole table?

No. IIRC the sample size is 300 * <largest column statistic setting>,
so at most 300k rows. In the current implementation, ANALYZE will
actually suck the entire sample into memory, so you really really don't
want it trying to analyze millions of rows anyway...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-30 00:04:06 Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Previous Message Doug McNaught 2003-09-29 23:35:18 Re: Rewriting pg_upgrade