On Fri, 31 May 2019 at 17:34, Pavel Stehule <pavel.steh...@gmail.com> wrote:
> Hi > > pá 31. 5. 2019 v 17:26 odesílatel Ivan Voras <ivo...@gmail.com> 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.
