From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Chris Jones <chris(at)mt(dot)sri(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: vacuum analyze again... |
Date: | 2001-02-20 17:25:12 |
Message-ID: | 200102201725.MAA07254@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>
> > No, we have no ability to randomly pick rows to use for estimating
> > statistics. Should we have this ability?
>
> That would be really slick, especially given the fact that VACUUM runs
> much faster than VACUUM ANALYZE for a lot of PG users. I could change
> my daily maintenance scripts to do a VACUUM of everything, followed by
> a VACUUM ANALYZE of the small tables, followed by a VACUUM ANALYZE
> ESTIMATE (or whatever) of the large tables.
>
> Even cooler would be the ability to set a table size threshold, so
> that VACUUM ANALYZE would automatically choose the appropriate method
> based on the table size.
Added to TODO:
* Allow ANALYZE to process a certain random precentage of rows
--
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 | Louis-David Mitterrand | 2001-02-20 17:27:07 | strategies for keeping an audit trail of UPDATEs |
Previous Message | Chris Jones | 2001-02-20 17:21:56 | Re: vacuum analyze again... |