Re: Support Parallel Query Execution in Executor - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Support Parallel Query Execution in Executor
Date
Msg-id 1144573086.3657.3.camel@localhost.localdomain
Whole thread Raw
In response to Re: Support Parallel Query Execution in Executor  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-hackers
Ühel kenal päeval, L, 2006-04-08 kell 18:47, kirjutas Luke Lonergan:

> I agree - there is a real continuing need for overlapped scan and execution,
> though I'm not sure quite how to get it efficiently using inter-process
> communication.  The AIO interface is nicely proven at this point, but to
> Tom's point, it's non-portable.
> 
> What we see now is that the executor is CPU bound at about 300MB/s scan rate
> using modern Opteron CPUs.  

Where exactly does the CPU spend its time at 300MB/s ? Is it mainly I/O
related processing,  processing pages into in-memory tuples or something
else ?

--------------
Hannu




pgsql-hackers by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Support Parallel Query Execution in Executor
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Support Parallel Query Execution in Executor