On Fri, 31 May 2019 at 17:34, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
Hipá 31. 5. 2019 v 17:26 odesílatel Ivan Voras <ivoras@xxxxxxxxx> napsal:Hello,autovacuum check tables once per minute, and working on closed transactions. Lot of times temporary tables are filled inside some batch, and immediately some query is started over this table. It is very low probability to analyze temp table at good time automatically. So only explicit call of ANALYZE is correct solution.
There are two types of workloads we're talking about: short ones, for which autovacuum is probably not worth it, and long-running ones (in our case, hours), where it is. So that's why I'm advocating a GUC toggle.
