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

From Adam Brusselback
Subject Re: Feature request (or at least discussion): enable autovaccum ontemp tables
Date
Msg-id CAMjNa7c0XeC197iQkq17WN0K0PdNV56ajVGzHLieZV90H0P3yA@mail.gmail.com
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
Temp tables are not visibile outside of a single connection, so the autovacuum worker connection isn't able to see it.

Are you sure that it's actually an issue with accumulating dead tuples, and not an issue with bad statistics?

In my processes which are heavy on temp tables, I have to manually run analyze after populating any temp tables.

Just a thought.
-Adam

pgsql-general by date:

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