On Tue, Jan 23, 2018 at 11:39 AM, Pavan Teja <pavan.postgres...@gmail.com> 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.
