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 по дате отправления: