Tom Lane wrote: > Christophe Pettus <xof@xxxxxxxxxxxx> writes: > > The problem indeed appear to be a very large number of subtransactions, each one creating a temp table, inside a single transaction. It's made worse by one of those transactions finally getting replayed on the secondary, only to have another one come in right behind it... > > Hmm, I tried to reproduce this and could not. I experimented with > various permutations of this: This problem is probably related to commit 9b013dc238c, which AFAICS is only in pg10, not 9.5. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
