Re: Multi CPU Queries - Feedback and/or suggestions wanted! - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Multi CPU Queries - Feedback and/or suggestions wanted!
Date
Msg-id ADECE6A0-3AFE-4769-A67A-7A5256FD2951@enterprisedb.com
Whole thread Raw
In response to Re: Multi CPU Queries - Feedback and/or suggestions wanted!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
We did discuss this in Ottawa and I beleive your comment was "the hint  
is in the name" referring to posix_fadvise.

In any case both aio and posix_fadvise are specified by posix so I  
don't see either as a problem on that front.

I don't think we can ignore any longer that we effectively can't use  
raid arrays with postgres. If you have many concurrent queries or  
restrict yourself to sequential scans you're ok but if you're doing  
data warehousing you're going to be pretty disappointed to see your  
shiny raid array performing like a single drive.


greg

On 24 Oct 2008, at 05:42 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Jonah H. Harris" <jonah.harris@gmail.com> writes:
>> On Thu, Oct 23, 2008 at 10:36 PM, Greg Stark
>>> In what way is fadvise a kludge?
>
>> non-portable, requires more user-to-system CPU, ... need I go on?
>
> I'd be interested to know which of these proposals you claim *is*
> portable.  The single biggest reason to reject 'em all is that
> they aren't.
>
>            regards, tom lane


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Multi CPU Queries - Feedback and/or suggestions wanted!
Next
From: Heikki Linnakangas
Date:
Subject: Re: Multi CPU Queries - Feedback and/or suggestions wanted!