Alvaro Herrera <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
