Re: pg_autovacuum: short, wide tables - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: pg_autovacuum: short, wide tables
Date
Msg-id 20050708165517.GB1915@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_autovacuum: short, wide tables  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: pg_autovacuum: short, wide tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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)

pgsql-bugs by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: pg_autovacuum: short, wide tables
Next
From: Tom Lane
Date:
Subject: Re: pg_autovacuum: short, wide tables