Re: 8.2 Autovacuum BUG ? - Mailing list pgsql-performance

From pavan95
Subject Re: 8.2 Autovacuum BUG ?
Date
Msg-id 1516708261537-0.post@n3.nabble.com
Whole thread Raw
In response to Re: 8.2 Autovacuum BUG ?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: 8.2 Autovacuum BUG ?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-performance
Hi Andreas,

Yes I'm facing problem because of this huge WAL(archive log) generation. As
it is seriously consuming a lot of disk space almost close to 50GB per day
even if the DML's don't have that impact in this WAL generation.

Previously the archive_log size is nearly 2 to 3 GB a day. Now with the same
set of DML's how is it being generated to 50GB is my burning doubt.

I just wanted to know how to stabilize this issue, as checking and deleting
the archive logs on hourly basis is not a good idea.

Finally, I'm looking how to reduce this back to normal. Thanks in Advance.

Regards,
Pavan  



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html


pgsql-performance by date:

Previous
From: pavan95
Date:
Subject: Re: 8.2 Autovacuum BUG ?
Next
From: Laurent Martelli
Date:
Subject: Bad plan