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

help / color / mirror / Atom feed
From: Soni M <diptatapa@gmail.com>
To: Heikki Linnakangas <hlinnakangas@vmware.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres Replaying WAL slowly
Date: Sun, 29 Jun 2014 20:05:49 +0700
Message-ID: <CAAMgDXnOKzSSUkntcLCDpe_fOu7MmEQ7AUaSTAPUaU5bph7c4Q@mail.gmail.com> (raw)
In-Reply-To: <CAAMgDXnKknBDk+Zb3BXau1cKV7y1A0vd9CJpX=vkSTXVGBrZwA@mail.gmail.com>
References: <CAAMgDXm5Y9QPELKvCGBrFvPcuR0ENVA1tEYRcazhDSxs6xnX5w@mail.gmail.com>
	<53AFCEE3.4080009@vmware.com>
	<CAAMgDXnKknBDk+Zb3BXau1cKV7y1A0vd9CJpX=vkSTXVGBrZwA@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

Here's some data from standby (this is when replaying take 44seconds per
wal files):

2014-06-29 00:07:36.513 CDT,,,16682,,53af6f46.412a,44,,2014-06-28 20:43:34
CDT,,0,LOG,00000,"restartpoint complete: wrote 63187 buffers (3.0%); 0
transaction log file(s) added, 0 removed, 0 recycled; write=209.170 s,
sync=0.482 s, total=209.667 s; sync files=644, longest=0.036 s,
average=0.000 s",,,,,,,,,""
2014-06-29 00:07:36.513 CDT,,,16682,,53af6f46.412a,45,,2014-06-28 20:43:34
CDT,,0,LOG,00000,"recovery restart point at 27CE/170056A8","last completed
transaction was at log time 2014-06-27 13:39:00.542624-05",,,,,,,,""
2014-06-29 00:28:59.678 CDT,,,16682,,53af6f46.412a,47,,2014-06-28 20:43:34
CDT,,0,LOG,00000,"restartpoint complete: wrote 70942 buffers (3.4%); 0
transaction log file(s) added, 0 removed, 0 recycled; write=209.981 s,
sync=0.493 s, total=210.486 s; sync files=723, longest=0.156 s,
average=0.000 s",,,,,,,,,""
2014-06-29 00:28:59.678 CDT,,,16682,,53af6f46.412a,48,,2014-06-28 20:43:34
CDT,,0,LOG,00000,"recovery restart point at 27CE/35002678","last completed
transaction was at log time 2014-06-27 13:42:05.121121-05",,,,,,,,""

-- 
Regards,

Soni Maula Harriz

view thread (33+ messages)  latest in thread

Message-ID: <CAAMgDXnOKzSSUkntcLCDpe_fOu7MmEQ7AUaSTAPUaU5bph7c4Q@mail.gmail.com>
Permalink:  ../CAAMgDXnOKzSSUkntcLCDpe_fOu7MmEQ7AUaSTAPUaU5bph7c4Q@mail.gmail.com/
Also on:    postgresql.org/message-id/CAAMgDXnOKzSSUkntcLCDpe_fOu7MmEQ7AUaSTAPUaU5bph7c4Q@mail.gmail.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: diptatapa@gmail.com, hlinnakangas@vmware.com
  Subject: Re: Postgres Replaying WAL slowly
  In-Reply-To: <CAAMgDXnOKzSSUkntcLCDpe_fOu7MmEQ7AUaSTAPUaU5bph7c4Q@mail.gmail.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