| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Pete Forman <pete(dot)forman(at)westerngeco(dot)com> |
| Cc: | Chris Jones <chris(at)mt(dot)sri(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: vacuum analyze again... |
| Date: | 2001-02-21 16:20:06 |
| Message-ID: | 200102211620.LAA19132@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > Added to TODO:
> >
> > * Allow ANALYZE to process a certain random precentage of
> > rows
>
> Does this reduced analysis need to be random? Why not allow the DBA
> to specify what rows or blocks to do in some way.
No, we are not about to add the kitchen sink here. If you really want
to control the statistics values, just update pg_attribute and
pg_statistics.
--
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 | And. Andruikhanov | 2001-02-21 16:27:01 | ELOG_TIMESTAMPS feature |
| Previous Message | Dan Lyke | 2001-02-21 16:12:46 | How to release SET() in PgSQL? |