From: Andreas Kretschmer <andreas@a-kretschmer.de>
To: pgsql-performance@lists.postgresql.org
Subject: Re: 8.2 Autovacuum BUG ?
Date: Tue, 23 Jan 2018 15:17:27 +0100
Message-ID: <be4983c9-ae44-f068-ee02-d4b7e4c8d2bd@a-kretschmer.de> (raw)
In-Reply-To: <1516708261537-0.post@n3.nabble.com>
References: <46D83427.60001@livedatagroup.com>
<1516601350338-0.post@n3.nabble.com>
<987851516614060@web46o.yandex.ru>
<1516616499481-0.post@n3.nabble.com>
<97fd02a3-c07c-6d27-6221-b50c2c8c13cc@a-kretschmer.de>
<1516708261537-0.post@n3.nabble.com>
Am 23.01.2018 um 12:51 schrieb pavan95:
> Hi Andreas,
>
> Yes I'm facing problem because of this huge WAL(archive log) generation. As
> it is seriously consuming a lot of disk space almost close to 50GB per day
> even if the DML's don't have that impact in this WAL generation.
>
> Previously the archive_log size is nearly 2 to 3 GB a day. Now with the same
> set of DML's how is it being generated to 50GB is my burning doubt.
Will so many wals continue to be produced?
>
> I just wanted to know how to stabilize this issue, as checking and deleting
> the archive logs on hourly basis is not a good idea.
Don't delete wal's!
> Finally, I'm looking how to reduce this back to normal. Thanks in Advance.
have you set archive_mode to on and defined an archive_command?
Wal-files will be reused after 2 checkpoints.
Is there something in the logs?
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andreas@a-kretschmer.de, pgsql-performance@lists.postgresql.org
Subject: Re: 8.2 Autovacuum BUG ?
In-Reply-To: <be4983c9-ae44-f068-ee02-d4b7e4c8d2bd@a-kretschmer.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox