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
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
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
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