Re: [GENERAL] WAL segments size

2007-11-12 Thread Greg Smith
On Mon, 12 Nov 2007, Bruno Almeida do Lago wrote: One of our PostgreSQL databases is generating archive logs too frequently, since the number of transactions/s (inserts & updates) is very high. If the problem is that the archive logs are too frequent, then suggestions so far like increasing c

Re: [GENERAL] WAL segments size

2007-11-12 Thread Scott Marlowe
On Nov 12, 2007 2:14 PM, Bruno Almeida do Lago <[EMAIL PROTECTED]> wrote: > Hi, > > One of our PostgreSQL databases is generating archive logs too frequently, > since the number of transactions/s (inserts & updates) is very high. > > I was looking for a parameter on postgresql.conf to increase the

Re: [GENERAL] WAL segments size

2007-11-12 Thread Andrew Sullivan
On Mon, Nov 12, 2007 at 05:14:24PM -0300, Bruno Almeida do Lago wrote: > I was looking for a parameter on postgresql.conf to increase the WAL > segments size, but according to documentation this can only be changed while > building PostgreSQL. You mean this: http://www.postgresql.org/docs/8.2/sta

[GENERAL] WAL segments size

2007-11-12 Thread Bruno Almeida do Lago
Hi, One of our PostgreSQL databases is generating archive logs too frequently, since the number of transactions/s (inserts & updates) is very high. I was looking for a parameter on postgresql.conf to increase the WAL segments size, but according to documentation this can only be changed while bui