"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes:
>> Bruce Momjian wrote:
>> Should pg_autovacuum be vacuuming temporary tables?
> This is a good question, and I would like some opinions from some other
> people more informed than I.
You *can not* vacuum other sessions' temp tables; you don't have access
to the data. (You have no way to get at pages that are modified in
someone else's local buffer manager.) You could vacuum your own temp
tables, if you had any, but I would hardly expect autovacuum to have
any.
In reference to Chris' followup question, you *should* be vacuuming
system catalogs, and you *should not* be vacuuming TOAST tables. VACUUM
on a regular table automatically hits the associated TOAST table.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
