Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
I could make the whole dataset available, but tarred and zipped it's
about 300Mb. The reason I used this dataset was that I wanted to see a
test that took many seconds, and Merlin's did not - I wanted to see how
any performance gain scaled.
Well, you tried to "scale" into a domain where the performance is going
to be disk-I/O-limited, so I'm not sure it proves anything.
Good point. I took a 5% random extract from the lineitems table and saw
the expected improvement.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly