Re: Feature request (or at least discussion): enable autovaccum on temp tables - Mailing list pgsql-general

From Andrew Gierth
Subject Re: Feature request (or at least discussion): enable autovaccum on temp tables
Date
Msg-id 87r28eaaxm.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Feature request (or at least discussion): enable autovaccum on temp tables  (Ivan Voras <ivoras@gmail.com>)
Responses Re: Feature request (or at least discussion): enable autovaccum ontemp tables
List pgsql-general
>>>>> "Ivan" == Ivan Voras <ivoras@gmail.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)



pgsql-general by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Feature request (or at least discussion): enable autovaccum ontemp tables
Next
From: Christopher Browne
Date:
Subject: Re: Feature request (or at least discussion): enable autovaccum ontemp tables