Re: pg_autovacuum: short, wide tables

> 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)