Alex,
On 11/18/05 8:28 AM, "Alex Turner" <armtuk@xxxxxxxxx> wrote:
> Ok - so I ran the same test on my system and get a total speed of
113MB/sec.
> Why is this? Why is the system so limited to around just
110MB/sec? I
> tuned read ahead up a bit, and my results improve a
bit..
OK! Now we're on the same page. Finally someone who actually tests!
Check the CPU usage while it's doing the scan. Know what it's doing?
Memory copies. We've profiled it extensively.
So - that's the suckage - throwing more CPU power helps a bit, but the
underlying issue is poorly optimized code in the Postgres executor and lack
of I/O asynchrony.
- Luke
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
