Re: Parallel Query should be a top priority

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Parallel Query should be a top priority
Date: 2005-03-28 06:06:32
Message-ID: d286um$1aev$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Mike Mascari" <mascarm(at)mascari(dot)com> writes
> "Consider parallel processing a single query" should be moved out from
> under Miscellaneous on the TODO list and re-categorized as the formerly
> existent URGENT feature...
>

Yes, inter/inner-operation of PQO could be an obvious winner in some
situations. For example, in a rather idle multi-processor machine, run a
complex query could get times of acceleration.

However, in some other cases, like in a quite busy machine, inter-query
parallel mechanism is already good enough, esp. for the system like PG using
MVCC concurrency control. I remember there was someone working on the
parallel scan idea of PG, I believe that's more realistic and benefitial
than the implementation of the full set of PQO.

Regards,
Qingqing

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph M. Day 2005-03-28 06:29:13 Linux Filesystem for PG
Previous Message Mike Mascari 2005-03-28 04:58:35 Parallel Query should be a top priority