Re: SSDs with Postgresql? - Mailing list pgsql-general

From Tom Lane
Subject Re: SSDs with Postgresql?
Date
Msg-id 24484.1303402938@sss.pgh.pa.us
Whole thread Raw
In response to Re: SSDs with Postgresql?  (Florian Weimer <fweimer@bfk.de>)
Responses Re: SSDs with Postgresql?
List pgsql-general
Florian Weimer <fweimer@bfk.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

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: SSDs with Postgresql?
Next
From: "Bob Pawley"
Date:
Subject: Re: Different views of remote server