BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
Дата
Msg-id 18821-fd87033e4102cf03@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18821
Logged by:          Marlene Saransig
Email address:      marle.saransig@gmail.com
PostgreSQL version: 15.2
Operating system:   Alma Linux 9.1
Description:

Need to eliminate files of /var/lib/pgsql/15/data/pg_wal/, because overcome
limit define in max_wal_size and this increase size used in hard disk

It is necesary to conserve files necesary to correct perfomance and
funcionality of database 

Actual configuration:

PostgreSQL 15.2
max_wal_size=4GB
min_wal_size=1GB
wal_level=logical
checkpoint_timeout=5min
wal_compression=off
shared_buffers=2560MB
archive_mode=off

du -sh /var/lib/pgsql/15/data/pg_wal/  obtain size 213GB
find /var/lib/pgsql/15/data/pg_wal/ -type f | wc -l  obtain numbers of files
13581


В списке pgsql-bugs по дате отправления: