hi,
On Fri, 31 May 2019 at 17:54, Christopher Browne <cbbrowne@xxxxxxxxx> wrote:
2. Temp tables are only associated (and visible) in the session in which you are doing the work. autovacuum operates inside an ordinary session context, and in a separate connected session, so it can't see your temp tables; they are not handled in shared memory that crosses contexts to the one in which those temp tables exist. Changing that would be way more difficult than meets the eye.
Hmm yeah, I forgot about that aspect - temp tables not going though shared buffers.
Thanks!
