FAQ
Hi,

Does autovacuum daemon work on tables created with TEMPORARY syntax?

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

Regards,
Gnanam

Search Discussions

  • Tom Lane at Aug 25, 2010 at 2:24 pm

    "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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-admin @
categoriespostgresql
postedAug 25, '10 at 10:47a
activeAug 25, '10 at 2:24p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Tom Lane: 1 post Gnanakumar: 1 post

People

Translate

site design / logo © 2022 Grokbase