Skip site navigation (1) Skip section navigation (2)

Re: Multi CPU Queries - Feedback and/or suggestions wanted!

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Greg Stark" <greg(dot)stark(at)enterprisedb(dot)com>
Cc: "Bruce Momjian" <bruce(at)momjian(dot)us>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, "Julius Stroffek" <Julius(dot)Stroffek(at)sun(dot)com>, pgsql-hackers(at)postgresql(dot)org, "Dano Vojtek" <danielkov(at)gmail(dot)com>
Subject: Re: Multi CPU Queries - Feedback and/or suggestions wanted!
Date: 2008-10-24 03:31:13
Message-ID: 36e682920810232031w33e92517g69300a32a82d5293@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Oct 23, 2008 at 10:36 PM, Greg Stark
<greg(dot)stark(at)enterprisedb(dot)com> wrote:
> I couldn't get async I/O to work on Linux. That is it "worked" but performed
> the same as reading one block at a time. On solaris the situation is
> reversed.

Hmm, then obviously you did something wrong, because my tests showed
it quite well.  Pull the source to iozone or fio.

> In what way is fadvise a kludge?

non-portable, requires more user-to-system CPU, ... need I go on?

-- 
Jonah H. Harris, Senior DBA
myYearbook.com

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-10-24 04:42:13
Subject: Re: Multi CPU Queries - Feedback and/or suggestions wanted!
Previous:From: Jonah H. HarrisDate: 2008-10-24 03:29:37
Subject: Re: Multi CPU Queries - Feedback and/or suggestions wanted!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group