From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: romdn@inbox.ru
Subject: BUG #16327: Too many files in pg_replslot folder
Date: Sun, 29 Mar 2020 14:48:36 +0000
Message-ID: <16327-0c7694188d99d4a0@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16327
Logged by: Dmitry Romanenko
Email address: romdn@inbox.ru
PostgreSQL version: 12.2
Operating system: Windows
Description:
Hello!
4.5 million rows are inserted from the temporary table. For each of the
three subscriptions, 712,000 xid-*-lsn-*-*.spill files of 3 GB are
generated. The following lines appear in the work log: ERROR: replication
slot is busy processing with PID. Replication stops working.
What to do?
PostgreSQL 12.2, compiled by Visual C++ build 1914, 64-bit
postgresql.auto.conf
max_connections = '30'
shared_buffers = '512MB'
effective_cache_size = '6GB'
maintenance_work_mem = '512MB'
checkpoint_completion_target = '0.9'
wal_buffers = '16MB'
default_statistics_target = '100'
work_mem = '21845kB'
min_wal_size = '2GB'
max_wal_size = '8GB'
max_worker_processes = '4'
max_parallel_workers_per_gather = '2'
max_parallel_workers = '4'
max_parallel_maintenance_workers = '2'
random_page_cost = '2'
P.S. Replication on PostgreSql 11.1 (with default settings) worked fine with
inserting 4.5 million rows. The xid - * - lsn - * - *. Snap files were
smaller and larger in size. But if there were several inserts in a row of
4.5 million lines, an error appeared: ERROR: out of memory.
Best regards, Dmitry
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, romdn@inbox.ru
Subject: Re: BUG #16327: Too many files in pg_replslot folder
In-Reply-To: <16327-0c7694188d99d4a0@postgresql.org>
References: <16327-0c7694188d99d4a0@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox