Re: [GENERAL] WAL Archiving frequency

[Brendan Duddridge]

Thanks Tom,




Thanks,

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  [EMAIL PROTECTED]

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:

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.

Brendan Duddridge <[EMAIL PROTECTED]> 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 an

increasing the checkpoint-spacing parameters, but you can't just say


Basically, you have to take base backups often enough that the total


                        regards, tom lane


TIP 2: Don't 'kill -9' the postmaster

unlikely rate of WAL generation. You can probably slow it down a bit by "don't generate so much WAL please". Either you want a log or you don't. number of WAL archive files needed stays under your threshold of pain... ---------------------------(end of broadcast)---------------------------

smime.p7s
Description: S/MIME cryptographic signature