| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, mark reid <mail(at)markreid(dot)org>, pgsql-bugs(at)postgresql(dot)org, Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Subject: | Re: pg_autovacuum: short, wide tables |
| Date: | 2005-07-08 16:55:17 |
| Message-ID: | 20050708165517.GB1915@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> Tom Lane wrote:
> >The first of these would be easiest but it seems quite likely to break
> >applications (eg, if unmodified, autovacuum would probably try to issue
> >vacuums against toast tables). And the last seems to be confusing.
> >So I think I favor adding columns.
Hmm. With integrated autovacuum, we could set something up to issue
vacuums separately to TOAST tables and the main table. It'd probably be
a tad easier if the toast stats are separate from the main table; and an
autovac of the main table not necessarily would invoke vacuuming the
toast table.
I'm not proposing it for 8.1 though ...
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-07-08 16:57:28 | Re: pg_autovacuum: short, wide tables |
| Previous Message | Mark Reid | 2005-07-08 16:48:22 | Re: pg_autovacuum: short, wide tables |