By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Very high WAL log generation in postgres9.5

P: 1
I am using postgres 9.5 for my production environment and enabled Archival for basebackup, from last one week I am getting high volume of WAL log generation from simple Update, Delete and Insert queries. What are the parameters which I can tune in postgresql.conf file for this server to reduce WAL logs, sometime it is generating 300GB in a hr.

Thanks in advance...
Jan 10 '17 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.