Re: SSDs with Postgresql?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Florian Weimer <fweimer(at)bfk(dot)de>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, Greg Smith <greg(at)2ndquadrant(dot)com>
Subject: Re: SSDs with Postgresql?
Date: 2011-04-21 16:22:18
Message-ID: 24484.1303402938@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Florian Weimer <fweimer(at)bfk(dot)de> writes:
> * Adrian Klaver:
>>> Interesting. Is there an easy way to monitor WAL traffic in away?

>> They are found in $DATA/pg_xlog so checking the size of that
>> directory regularly would get you the information.

> But log files are recycled, so looking at the directory alone does not
> seem particularly helpful.

"du" would be useless, but you could check the name of the newest WAL
segment file from time to time, and do a bit of math to see how much
WAL had been written since the previous time.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2011-04-21 16:24:57 Re: Different views of remote server
Previous Message Greg Smith 2011-04-21 16:10:40 Re: SSDs with Postgresql?