Handling Huge wal files

From: satish v <vuyyuru(dot)satish59(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Handling Huge wal files
Date: 2021-07-19 10:31:52
Message-ID: CAPG-CvX_a-c9ix7SdzExKV6_rpkFV8c-yr-k5mE47UWHu+9wyQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2021-07-19 10:37:42 pg_dump and locks
Previous Message Thomas Kellerer 2021-07-18 14:54:08 Re: Need query