Re: [GENERAL] WAL Archiving frequency

2006-04-01 Thread Alan Hodgson
On March 31, 2006 10:39 pm, Brendan Duddridge <[EMAIL PROTECTED]> wrote: > 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. That's normal, if your database is busy. I get up to 6

Re: [GENERAL] WAL Archiving frequency

2006-03-31 Thread Brendan Duddridge
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 | [EMAIL P

Re: [GENERAL] WAL Archiving frequency

2006-03-31 Thread Tom Lane
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 nothi

[GENERAL] WAL Archiving frequency

2006-03-31 Thread Brendan Duddridge
Hi,I've setup WAL file archiving to my SAN storage over the network (using an NFS mount to the file server).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 n