| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Jean-Christophe Boggio <cat(at)thefreecat(dot)org> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: vacuum analyze again... |
| Date: | 2001-02-20 15:32:21 |
| Message-ID: | 200102201532.KAA25347@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
[ Charset ISO-8859-1 unsupported, converting... ]
> Hi,
>
> In Oracle, there are 2 ways to do the equivalent of vacuum analyze :
>
> * analyze table xx compute statitics
> * analyze table xx estimate statistics
>
> In the second form, you can tell on what percentage of the file you
> will do your stats. This is useful to make a quick analyze on huge tables
> that have a homogenous dispersion.
>
> Is there a way to "estimate" the statistics that vacuum analyze will
> use instead of "computing" them ?
No, we have no ability to randomly pick rows to use for estimating
statistics. Should we have this ability?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brent R. Matzelle | 2001-02-20 15:34:20 | Re: Row ID and auto-increment? |
| Previous Message | Brett W. McCoy | 2001-02-20 15:30:40 | Re: Re: binding postmaster to *one* virtual IP address |