It is generally a very bad idea to turn off autovacuum. When it is causing
problems, it is likely that it needs to run more often to keep up with the
work, rather than not run at all. Certainly if it is turned off, it would
be critical to have a regularly scheduled process to vacuum analyze all
tab
On Wed, 2020-04-29 at 08:54 +0200, Marc Rechté wrote:
> I am trying to figure out the recommended settings for a PG dedicated
> machine regarding NUMA.
>
> I assume that the shared buffers are using Huge Phages only. Please
> correct if I am wrong:
>
> 1) postgres is started with numactl --inte
