How to build with bigger WAL segment file?

From: "Clodoaldo Pinto" <clodoaldo(dot)pinto(at)gmail(dot)com>
To: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How to build with bigger WAL segment file?
Date: 2006-06-19 13:11:11
Message-ID: a595de7a0606190611l4414b89eyc77bfdc7963f53ea@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Since I have a database with a frequent and huge update batch, the WAL
segment file number is about 130. I suspect these files management
during the update is hurting performance. Is it likely? I'm using
Fedora Core 3 and checkpoint_segments is set to 64.

To overcome this I'm considering to make the WAL segment files bigger.
The segment file default size is 16 MB. How to build from the source
rpm to have bigger files, say 128 MB?

Regards, Clodoaldo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2006-06-19 13:26:43 Re: Question about openSSL
Previous Message Relyea, Mike 2006-06-19 12:46:53 Re: Out of memory error in 8.1.0 Win32