Tom Lane wrote:
>Andrew Dunstan <andrew@dunslane.net> 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