pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: 8.2 Autovacuum BUG ?
Date: Tue, 23 Jan 2018 23:54:39 -0700 (MST)
Message-ID: <1516776879945-0.post@n3.nabble.com> (raw)
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>

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




view thread (46+ messages)  latest in thread

Message-ID: <1516776879945-0.post@n3.nabble.com>
Permalink:  ../1516776879945-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1516776879945-0.post@n3.nabble.com

 · 

reply
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: pavan.postgresdba@gmail.com
  Subject: Re: 8.2 Autovacuum BUG ?
  In-Reply-To: <1516776879945-0.post@n3.nabble.com>

* 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