On Wed, Dec 22, 2021 at 8:50 PM Fabrice Chapuis <fabrice636...@gmail.com> wrote: > > Hello Amit, > > I was able to reproduce the timeout problem in the lab. > After loading more than 20 millions of rows in a table which is not > replicated (insert command ends without error), errors related to logical > replication processes appear in the postgres log. > Approximately every 5 minutes worker process is restarted. The snap files in > the slot directory are still present. The replication system seems to be > blocked. Why these snap files are not removed. What do they contain? >
These contain changes of insert. I think these are not removed for your case as your long transaction is never finished. As mentioned earlier, for such cases, it is better to use 'streaming' feature released as part of PG-14 but anyway here we are trying to debug timeout problem. > I will recompile postgres with your patch to debug. > Okay, that might help. -- With Regards, Amit Kapila.
