Luke Lonergan wrote:
Mark,
On 11/18/05 3:46 PM, "Mark Kirkwood" <markir@xxxxxxxxxxxxxxx> wrote:
If you alter this to involve more complex joins (e.g 4. way star) and
(maybe add a small number of concurrent executors too) - is it still the
case?
I may not have listened to you - are you asking about whether the
readahead works for these cases?
I’ll be running some massive TPC-H benchmarks on these machines soon –
we’ll see then.
That too, meaning the business of 1 executor random reading a given
relation file whilst another is sequentially scanning (some other) part
of it....
Cheers
Mark
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
