Re: Huge archive log generate in Postgresql-13

From: Clive Swan <cliveswan(at)gmail(dot)com>
To: Holger Jakobs <holger(at)jakobs(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Huge archive log generate in Postgresql-13
Date: 2022-04-18 19:15:38
Message-ID: CWXP123MB3959D7C4AB99BE0D1D6F38F4A0F39@CWXP123MB3959.GBRP123.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Grenting,
Is your logging set to high verbosity??

Usually use high verbosity for debugging, then change to low verbosity.

Clive

________________________________
From: Holger Jakobs <holger(at)jakobs(dot)com>
Sent: Monday, 18 April 2022, 13:10
To: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Huge archive log generate in Postgresql-13

wal_level = hot_standby # minimal, replica, or logical
# (change requires restart)

Set wal_level to one of the allowed values. It's possible that your value gets interpreted as logical, thus creating larger wal entries.

Am 18.04.22 um 13:47 schrieb Ram Pratap Maurya:
Hi Support,

We have upgraded postgresql DB from version 11 to 13 . after upgrade to 13 huge archive log generate in system .
Before upgrade per day 120GB to 150 GB log generated but after upgrade per day approx. 250 to 300 GB log generated.
Can you please suggest why huge archive log generated after upgrade there any configure setting or this is Postgresql-13 behaviour.

Postgresql-13 Postgresql conf file attached for your references.

Regards,
Ram Pratap.

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ram Pratap Maurya 2022-04-19 03:29:49 RE: Huge archive log generate in Postgresql-13
Previous Message Adrian Klaver 2022-04-18 16:00:20 Re: Huge archive log generate in Postgresql-13

Browse pgsql-general by date

  From Date Subject
Next Message Pete O'Such 2022-04-18 20:12:47 No psql md5 auth, psql 14.1 to PG 11
Previous Message Alban Hertroys 2022-04-18 19:14:11 Re: Puzzline CROSS JOIN when doing RECURSIVE CTE