| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Glen Parker <glenebob(at)nwlink(dot)com> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum Improvements |
| Date: | 2006-12-20 01:18:19 |
| Message-ID: | 20061220011819.GV3036@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Glen Parker wrote:
> I'd also like to use some of this information to issue reindex and
> cluster commands only when they're needed. In fact, on days when I
> cluster, there's no need whatsoever to also vacuum those tables. This
> is something that autovacuum won't do at all.
Well, I'd rather fix CLUSTER so that it reports that there are currently
no dead tuples in the table. This should be an easy patch that, hey,
maybe you could contribute ;-)
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-12-20 01:25:50 | Re: Autovacuum Improvements |
| Previous Message | Glen Parker | 2006-12-20 01:16:48 | Re: Autovacuum Improvements |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-12-20 01:18:50 | Re: effective_cache_size vs units |
| Previous Message | Glen Parker | 2006-12-20 01:16:48 | Re: Autovacuum Improvements |