Re: Feature request (or at least discussion): enable autovaccum on temp tables

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Ivan Voras <ivoras(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Feature request (or at least discussion): enable autovaccum on temp tables
Date: 2019-05-31 15:43:44
Message-ID: 87r28eaaxm.fsf@news-spur.riddles.org.uk
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "Ivan" == Ivan Voras <ivoras(at)gmail(dot)com> writes:

Ivan> Since AFAIK temp tables are very close to unlogged ordinary
Ivan> tables, what would stop this feature from being implemented?

The key difference between temp tables and other tables is that temp
table data does not use the shared_buffers but is buffered only in
backend-local memory.

This means that other processes (like, say, an autovacuum process) can
not access the content of temp tables. So what you want is not possible.

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2019-05-31 15:54:00 Re: Feature request (or at least discussion): enable autovaccum on temp tables
Previous Message Ivan Voras 2019-05-31 15:42:38 Re: Feature request (or at least discussion): enable autovaccum on temp tables