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

From Ivan Voras
Subject Re: Feature request (or at least discussion): enable autovaccum ontemp tables
Date
Msg-id CAF-QHFXWKe5iA+bLVM6wo8jP__R6HmoXCLVHcucwhkUwkJ7_BQ@mail.gmail.com
Whole thread Raw
In response to Re: Feature request (or at least discussion): enable autovaccum ontemp tables  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-general
On Fri, 31 May 2019 at 17:38, Adam Brusselback <adambrusselback@gmail.com> wrote:
Temp tables are not visibile outside of a single connection, so the autovacuum worker connection isn't able to see it.

I can connect as a superuser via psql while temp tables are being used and I can examine tables in the pg_temp_* schemas, so that particular separation isn't really a strong one. If there's a reason why autovacuum isn't doable on temp tables, it's not that one. (maybe autovacuum would work on the tables while the session disconnects, preventing the temp tables from being dropped?)

 

pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Feature request (or at least discussion): enable autovaccum ontemp tables
Next
From: Andrew Gierth
Date:
Subject: Re: Feature request (or at least discussion): enable autovaccum on temp tables