pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: James Rogers <jamesr@best.com>
To: pgsql-performance@postgresql.org
Subject: Re: One or more processor ?
Date: 13 Oct 2003 11:43:43 -0700
Message-ID: <1066070623.18133.15.camel@localhost.localdomain> (raw)
In-Reply-To: <20031013115204.S51447-100000@pool.imt.com.ua>
References: <20031013115204.S51447-100000@pool.imt.com.ua>

On Mon, 2003-10-13 at 01:53, Andriy Tkachuk wrote:
> > >>Do you know of any RDBMS that actually will execute a single query
> > >>on multiple processors?
> > >
> Oracle, i think, on partitioned tables.



This makes a certain amount of sense.  It be much easier to allow this
on partitioned tables than in the general case, since partitioned tables
look a lot like multiple relations hiding behind a view and one could
simply run one thread per partition in parallel without any real fear of
contention on the table.  This is doubly useful since partitioned tables
tend to be huge almost by definition.

Offhand, it would seem that this would be a feature largely restricted
to threaded database kernels for a couple different pragmatic reasons.

Cheers,

-James Rogers
 jamesr@best.com





view thread (14+ messages)

Message-ID: <1066070623.18133.15.camel@localhost.localdomain>
Permalink:  ../1066070623.18133.15.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1066070623.18133.15.camel@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jamesr@best.com
  Subject: Re: One or more processor ?
  In-Reply-To: <1066070623.18133.15.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox