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

From: Adam Brusselback <adambrusselback(at)gmail(dot)com>
To: Ivan Voras <ivoras(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Feature request (or at least discussion): enable autovaccum on temp tables
Date: 2019-05-31 15:40:15
Message-ID: CAMjNa7c0XeC197iQkq17WN0K0PdNV56ajVGzHLieZV90H0P3yA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

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