Skip site navigation (1) Skip section navigation (2)

Re: Increasing WAL usage followed by sudden drop

From: delongboy <sdelong(at)saucontech(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Increasing WAL usage followed by sudden drop
Date: 2012-08-23 14:43:18
Message-ID: 1345732998244-5720953.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-performance
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-tp5719567p5720953.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


In response to

pgsql-performance by date

Next:From: Felix SchubertDate: 2012-08-24 09:47:45
Subject: Slow Performance on a XEON E5504
Previous:From: Merlin MoncureDate: 2012-08-23 13:32:12
Subject: Re: Performance of Seq Scan from buffer cache

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group