"Gnanakumar" <gnanam@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin