I seem to have some obscure problem with the WAL logs (AFAIK that's what
is stored in the pg_xlog directory):
63G /var/lib/postgres/data/pg_xlog
This is a bit too much wasted space for my taste. 8-/
egrep -i 'wal|checkpoint' /etc/postgresql/postgresql.conf | grep -v ^#
returns:
wal_buffers = 64 # min 4, typically 8KB each
checkpoint_segments = 8 # in logfile segments, min 1, 16MB each
The machine is running version 7.3.2r1-5 of the Debian package.
Any suggestions?