Thread: Autovacuum daemon & TEMPORARY tables

Autovacuum daemon & TEMPORARY tables

From
"Gnanakumar"
Date:
Hi,

Does autovacuum daemon work on tables created with TEMPORARY syntax?

CREATE [ { TEMPORARY | TEMP } ] TABLE table_name ...

Regards,
Gnanam


Re: Autovacuum daemon & TEMPORARY tables

From
Tom Lane
Date:
"Gnanakumar" <gnanam@zoniac.com> writes:
> Does autovacuum daemon work on tables created with TEMPORARY syntax?

No.  It can't, because it's unsafe for any session except the creating
session to touch a temporary table.  The performance optimizations used
for temp tables have that unfortunate side-effect.

            regards, tom lane