Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there any way to force analyze to run on a whole table? - Mailing list pgsql-general

From Tom Lane
Subject Re: Is there any way to force analyze to run on a whole table?
Date
Msg-id 13455.1064879672@sss.pgh.pa.us
Whole thread Raw
In response to Is there any way to force analyze to run on a whole table?  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Tree view 
Joseph Shraibman <jks@selectacast.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

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Rewriting pg_upgrade
Next
From: Phil Campaigne
Date:
Subject: psql error:cannot open libpq.so.3