[Bizgres-general] Performance - WAL bypass + parse

[Mark Kirkwood]

Mark Kirkwood wrote:

> 
> Anyway, I will try out your test program and patch.
> 
> Cheers
> 
> Mark
> 

Some numbers comparing before and after:

FreeBSD 5.4
2xPIII 700Mhz, 2G + 2 disk IDE RAID 0

3.5G test file, single column table with VARCHAR datatype.

Pg 8.0.3 : 2.8M/s
Pg 8.0.3 + fast parse : 3.2M/s

This is about a 14% improvement - dramatically smaller than we were 
expecting. I did wonder if the issue is the poor memory bandwidth 
(100Mhz) or a FreeBSD thing - but I can get 6M/s using Mysql 5.0.4 on 
this same machine, loading this file, so I suspect now. Hmmm, will get 
the profiler out an' see...

As a check to see if my test method was broken, tried the same test on 
my MacOSX 10.3 ibook and saw a 50% improvement (the numbers were feeble 
- 0.8M/s improved to 1.2M/s, but the change is in keeping with what you 
guys are seeing)!