pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHandling Huge wal files
2+ messages / 2 participants
[nested] [flat]
* Handling Huge wal files
@ 2021-07-19 10:31 satish v <vuyyuru.satish59@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: satish v @ 2021-07-19 10:31 UTC (permalink / raw)
To: pgsql-admin
Hi,
we are using the postgresql, we have to table avg 1500 records which
stores the documents.when i am deleting the records of 4 days there are
huge number of huge files are generated and getting the error like
'requested wal files are already removed'.
max_wal_size is 32GB.
How to handle these scenarios.
thanks in advance.
Regards,
Satish.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Handling Huge wal files
@ 2021-07-19 10:53 Laurenz Albe <laurenz.albe@cybertec.at>
parent: satish v <vuyyuru.satish59@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2021-07-19 10:53 UTC (permalink / raw)
To: satish v <vuyyuru.satish59@gmail.com>; pgsql-admin
On Mon, 2021-07-19 at 16:01 +0530, satish v wrote:
> we are using the postgresql, we have to table avg 1500 records which stores the documents.
> when i am deleting the records of 4 days there are huge number of huge files are generated
> and getting the error like 'requested wal files are already removed'.
> max_wal_size is 32GB.
> How to handle these scenarios.
Use a replication slot.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-07-19 10:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-07-19 10:31 Handling Huge wal files satish v <vuyyuru.satish59@gmail.com>
2021-07-19 10:53 ` Laurenz Albe <laurenz.albe@cybertec.at>
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