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

help / color / mirror / Atom feed
From: delongboy <sdelong@saucontech.com>
To: pgsql-performance@postgresql.org
Subject: Re: Increasing WAL usage followed by sudden drop
Date: Thu, 23 Aug 2012 07:43:18 -0700 (PDT)
Message-ID: <1345732998244-5720953.post@n5.nabble.com> (raw)
In-Reply-To: <CAMkU=1yPTF7YQnn=kWepoX3=9GB3D5N8Jz3Fe6gfd-YF1XCafg@mail.gmail.com>
References: <385621813.89890122.1344620116156.JavaMail.root@email>
	<5029A543.4090503@agliodbs.com>
	<1345134711660-5720136.post@n5.nabble.com>
	<801082735.54549.1345215661255.JavaMail.root@agliodbs.com>
	<1345226019192-5720250.post@n5.nabble.com>
	<CAMkU=1xo=o8+wA5Pa=P18OcdBwKx0J=0PCy+HBUDVPsazX3i4Q@mail.gmail.com>
	<1345495869310-5720492.post@n5.nabble.com>
	<CAMkU=1yPTF7YQnn=kWepoX3=9GB3D5N8Jz3Fe6gfd-YF1XCafg@mail.gmail.com>


Jeff Janes wrote
> 
> It seems like it shouldn't be all that hard to write a tool to parse
> WAL logs in a context-free basis (i.e. without the backup to start
> applying them to) and emit some kind of descriptions of the records
> and their sizes.  But I don't know about such a tool already existing,
> and am not able to offer to create one.  (And assuming one existed,
> keeping it in sync with the main code would be a continuing problem)
> 

I appreciate your help Jeff.  I have come across what would seem such a
tool.
Its called xlogdump
I am working on getting it installed, having issues with libs I think at the
moment. I will let you know how it works out.

Thank you everybody for your input!



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Increasing-WAL-usage-followed-by-sudden-drop-tp5719567p57209...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.




view thread (10+ messages)

Message-ID: <1345732998244-5720953.post@n5.nabble.com>
Permalink:  ../1345732998244-5720953.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1345732998244-5720953.post@n5.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: sdelong@saucontech.com
  Subject: Re: Increasing WAL usage followed by sudden drop
  In-Reply-To: <1345732998244-5720953.post@n5.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