Re: Support Parallel Query Execution in Executor

From: Hannu Krosing <hannu(at)skype(dot)net>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: Gregory Maxwell <gmaxwell(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Support Parallel Query Execution in Executor
Date: 2006-04-09 08:58:06
Message-ID: 1144573086.3657.3.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Ü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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2006-04-09 09:11:18 Re: Support Parallel Query Execution in Executor
Previous Message Luke Lonergan 2006-04-09 05:29:05 Re: Support Parallel Query Execution in Executor

Browse pgsql-patches by date

  From Date Subject
Next Message Qingqing Zhou 2006-04-09 09:11:18 Re: Support Parallel Query Execution in Executor
Previous Message Luke Lonergan 2006-04-09 05:29:05 Re: Support Parallel Query Execution in Executor