On 9/23/19 2:34 PM, Corey Taylor wrote:
On Mon, Sep 23, 2019 at 4:31 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
Hmm, are there triggers on wss_entries that are UPDATEing/DELETEing
entries elsewhere?
No, that table is pretty much stand-alone. What we're seeing here is
most likely caused by the initial copy of the legacy db tables.
This happens when creating the local test db which I do right before the
tests. I can avoid the issue if I monitor top and wait for the analyze
to complete on all the related tables.
Big hammer approach:
alter system set autovacuum = off;
SELECT pg_reload_conf();
Do work
alter system reset autovacuum;
SELECT pg_reload_conf();
Smaller hammer:
https://www.postgresql.org/docs/11/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS
"autovacuum_enabled, toast.autovacuum_enabled (boolean)"
which can be done by ALTER TABLE also:
https://www.postgresql.org/docs/11/sql-altertable.html
corey
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
