Postgres Pro
Downloads
Home   >   mailing lists

Vacuuming generates huge WALs - Mailing list pgsql-admin

From Murthy Nunna
Subject Vacuuming generates huge WALs
Date
Msg-id BD7563973EF8894D905C80593EE9A4ED32177D@MAIL01.fnal.gov
Whole thread Raw
Responses Re: Vacuuming generates huge WALs
List pgsql-admin
Tree view

Hi All,

 

I am running version 9.2.4 and my database is configured for replication. My database is about 1.5TB.

 

Our manual vacuum process runs for about 5 hours and during this time there is lot of WAL files generated. Even the server load goes up due to this heavy IO activity. Because of the replication, all these WALs are shipped to standby server and there is also heavy IO load on the standby server. We run read only queries on standby server so it is having user impact there as well.

 

This is probably catch 22 but I am wondering if there is any way we can decrease this WAL activity during vacuum?

 

Thanks in advance for your advice/comments.

 

Murthy

pgsql-admin by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: Error: pid file is invalid, please manually kill the stale server process.
Next
From: Payal Singh
Date:
Subject: Re: Vacuuming generates huge WALs