Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1eeExK-0006vT-9B
	for pgsql-performance@arkaria.postgresql.org; Wed, 24 Jan 2018 06:54:46 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1eeExJ-0004l2-MT
	for pgsql-performance@arkaria.postgresql.org; Wed, 24 Jan 2018 06:54:45 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <pavan.postgresdba@gmail.com>)
	id 1eeExJ-0004kr-C2
	for pgsql-performance@lists.postgresql.org; Wed, 24 Jan 2018 06:54:45 +0000
Received: from n3.nabble.com ([162.255.23.22])
	by makus.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pavan.postgresdba@gmail.com>)
	id 1eeExE-0003yF-Pp
	for pgsql-performance@postgresql.org; Wed, 24 Jan 2018 06:54:44 +0000
Received: from n3.nabble.com (localhost [127.0.0.1])
	by n3.nabble.com (Postfix) with ESMTP id E7563ACD2791
	for <pgsql-performance@postgresql.org>; Tue, 23 Jan 2018 23:54:39 -0700 (MST)
Date: Tue, 23 Jan 2018 23:54:39 -0700 (MST)
From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1516776879945-0.post@n3.nabble.com>
In-Reply-To: 
 <CAGTBQpYkYXemTpuNwVMhV-EiwUBiBhiqO2rtAgFXxWy0kF15QA@mail.gmail.com>
References: <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>
 <be4983c9-ae44-f068-ee02-d4b7e4c8d2bd@a-kretschmer.de>
 <CACh9nsb5dF6wNC=iyaxGyrHZ212QkbtXtO36it9u-QhOFr6j2g@mail.gmail.com>
 <CAGTBQpYhg_Ow3SBmUd4=ycepDp5eJin-ou1kBAasQ5EyuE-n+A@mail.gmail.com>
 <CACh9nsYX23u1eLngVx2j5_0CBhUH=MJN9HE6iYOSgNrk5gfnFw@mail.gmail.com>
 <CAGTBQpYkYXemTpuNwVMhV-EiwUBiBhiqO2rtAgFXxWy0kF15QA@mail.gmail.com>
Subject: Re: 8.2 Autovacuum BUG ?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

Hi Claudio,

We didn't configure any replication to our production server. Which strace
are you talking about?

We did a keen observation that only at the time 9'th minute of the hour and
39'th minute of the hour the so called archive logs are generated even when
nobody is connecting from application(off the business hours). Minimum of 76
files are being produced in these two intervals of a hour. Tried to monitor
the DML's but those are the same DML's which were in the past. Any idea??

Thanks in advance.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html