Re: Hardware/OS recommendations for large databases ( - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Hardware/OS recommendations for large databases (
Date
Msg-id 437E8DA5.1050703@paradise.net.nz
Whole thread Raw
In response to Re: Hardware/OS recommendations for large databases (  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: Hardware/OS recommendations for large databases (
List pgsql-performance
Luke Lonergan wrote:
> Mark,
>
> On 11/18/05 3:46 PM, "Mark Kirkwood" <markir@paradise.net.nz> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: no value found for parameter 1 with JDBC and Explain Analyze
Next
From: "anon permutation"
Date:
Subject: What is the max number of database I can create in an instance of pgsql?