On Jun 19, 2006, at 4:10 PM, Clodoaldo Pinto wrote:
2006/6/19, Clodoaldo Pinto <[EMAIL PROTECTED]>:
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?
I found it in src/include/pg_config_manual.h:
BTW, someone (Mark Wong?) recently posted some performance testing
results from upping XLOG_SEG_SIZE... take a look in the archives.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
