Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux