how to measure wal_buffer usage

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: how to measure wal_buffer usage
Date: 2012-03-15 19:22:38
Message-ID: CAP=oouEiQonSexM2Mm6OfF6hRNJrRRQHkvTsEipc47K=atKSfw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

After reading this interesting article on shared_buffers and wal_buffers:
http://rhaas.blogspot.com/2012/03/tuning-sharedbuffers-and-walbuffers.html

it got me wondering if my settings were ideal. Is there some way to
measure wal_buffer usage in real time, so that I could simply monitor
it for some period of time, and then come up with a way of determining
if the current setting is sufficient?

I tried googling, but every reference that I've found simply defaults
to the "trial & error" approach to performance tuning.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-03-15 19:30:13 Re: Using copy with a file containing blank rows
Previous Message Bret Stern 2012-03-15 17:04:42 Re: Backups