Re: Autovacuum and toast tables

Alvaro Herrera <alvherre@commandprompt.com> writes:
> I think there is some special code in tqual.c that skips some checks
> assuming that the toast table is vacuumed at the same time as the main
> heap.

I don't believe there is any such connection.  We do use a special
snapshot for toast tables, but it's only needed to make sure VACUUM FULL
on a toast table will work (ie, we have to respect MOVED_IN/MOVED_OFF).

> We go certain lengths in autovacuum to make sure tables are vacuumed
> when their toast table needs vacuuming and the main table does not,
> which is all quite kludgy.

Yeah --- getting rid of that mess would be a plus.
        regards, tom lane