On Tue, Jan 23, 2018 at 11:39 AM, Pavan Teja <pavan.postgresdba@xxxxxxxxx> wrote:
Yes so many wals are continuing to be produced.Deleting the wals after a backup of the database.Yes archiving mode is on. And the warning message in log file is" checkpoints are frequently occurring (1second apart). Consider increasing checkpoint_segements parameter".My doubt is previously the same are the parameters which are reflected as of now. Then what is the point in considering altering those values. Correct me if I am wrong.
You can use pg_xlogdump to inspect those logs and see which relations/transactions are generating so much WAL.
Then you can hunt within your apps which code is responsible for that traffic, or whether it in fact is autovacuum.
