hi,
On Fri, 31 May 2019 at 17:54, Christopher Browne <cbbrowne(at)gmail(dot)com> 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!