Parallel queries

From: Michael Ansley <Michael(dot)Ansley(at)intec-telecom-systems(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Parallel queries
Date: 2001-01-31 14:18:57
Message-ID: 7F124BC48D56D411812500D0B747251480F3B8@FILESERVER002
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

All,

How hard would it be to get a back end to hand off parts of a query tree to
other back ends (which it created), and then collate the results, and take
it from there? Obviously, it would only do this under certain conditions,
specifically, if it was compiled in to the server, and the query tree in
question had a particular profile, i.e.: lent itself to parallel processing.
But surely it couldn't be that difficult to get a back end to hand off, say,
a sub-select sub-tree, or UNION sub-trees. Under heavy loads with the right
hardware, this could gain significant performance improvement.

Michael Ansley

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
Nick West - Global Infrastructure Manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martin A. Marques 2001-01-31 18:02:08 Re: grant privileges to a database
Previous Message m w 2001-01-31 13:18:27 Re: AW: AW: Like vs '=' bug with indexing