| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | marle(dot)saransig(at)gmail(dot)com |
| Subject: | BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size |
| Date: | 2025-02-20 17:42:40 |
| Message-ID: | 18821-fd87033e4102cf03@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18821
Logged by: Marlene Saransig
Email address: marle(dot)saransig(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Belyashov | 2025-02-20 19:17:18 | Re: BUG #18815: Logical replication worker Segmentation fault |
| Previous Message | Junwang Zhao | 2025-02-20 12:35:12 | Re: Possible Bug in JSON_QUERY() Behavior in PostgreSQL 17 |