> 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) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq