Thanks Tom,I just didn't know if that was normal or not. I actually saw 4 WAL files / minute today. I set checkpoint_segments = 128, so maybe that will help.
Thanks, ____________________________________________________________________ Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@xxxxxxxxxxxxxx ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Mar 31, 2006, at 8:47 PM, Tom Lane wrote:
Brendan Duddridge <brendan@xxxxxxxxxxxxxx> writes:I've noticed that it's archiving the 16 MB wal files about once every minute. Is this normal? There's a huge number of files in my wal_archives directory now. Is there a parameter to tell it not to archive so frequently? Or is this nothing to be too concerned about?If you've got a reasonably active database, 16MB/minute is not anunlikely rate of WAL generation. You can probably slow it down a bit byincreasing the checkpoint-spacing parameters, but you can't just say"don't generate so much WAL please". Either you want a log or you don't.Basically, you have to take base backups often enough that the totalnumber of WAL archive files needed stays under your threshold of pain...regards, tom lane---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
