doubt

Narasimha Rao P.A wrote:

Does postgreSQL support distributive query processing

No.

Get the freedom to save as many mails as you wish. Click here to know
how.
<http://in.rd.yahoo.com/tagline_mail_5/*http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/&gt;

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

On Wed, 11 Jul 2007, Narasimha Rao P.A wrote:

Does postgreSQL support distributive query processing

Not internally. It's possible in some situations to split queries up
across multiple nodes using add-on software. pgpool-II, available at
http://pgfoundry.org/projects/pgpool/ provides an implementation of
distributed queries if your table has a type of key such that you split
across it, but it's relatively immature software and you would have to
look at it very carefully to see if that parallel query implementation
could fit your needs.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

Ühel kenal päeval, K, 2007-07-11 kell 19:08, kirjutas Greg Smith:

On Wed, 11 Jul 2007, Narasimha Rao P.A wrote:

Does postgreSQL support distributive query processing

Not internally. It's possible in some situations to split queries up
across multiple nodes using add-on software. pgpool-II, available at
http://pgfoundry.org/projects/pgpool/ provides an implementation of
distributed queries if your table has a type of key such that you split
across it, but it's relatively immature software

Actually it is not "immature" at all, it is used 24/7 doing tens of
thousands of queries per second :P

But it is limited (by design) in what it can do - it is meant to run a
postgresql _function_ on one or more db hosts based on parameter
hash(es).

This can be used as a tool to construct a system which does distributed
queries, and also to distribute load on small OLTP queries over a set of
databases.

and you would have to
look at it very carefully to see if that parallel query implementation
could fit your needs.

It has no parallel query implementation by itself (other than a special
running the same SQL on a set of hosts and merging the results), but you
definitely can progrem on using pgpool.

If you need something to distribute queries over a number of hosts
automatically, there is a commercial data warehousing product (based on
postgresql) available from greenplum, which does exactly this:

http://www.greenplum.com/index.php?page=greenplum-database

Ühel kenal päeval, N, 2007-07-12 kell 14:00, kirjutas Hannu Krosing:

Ühel kenal päeval, K, 2007-07-11 kell 19:08, kirjutas Greg Smith:

On Wed, 11 Jul 2007, Narasimha Rao P.A wrote:

Does postgreSQL support distributive query processing

Not internally. It's possible in some situations to split queries up
across multiple nodes using add-on software. pgpool-II, available at
http://pgfoundry.org/projects/pgpool/ provides an implementation of
distributed queries if your table has a type of key such that you split
across it, but it's relatively immature software

Actually it is not "immature" at all, it is used 24/7 doing tens of
thousands of queries per second :P

uups, I thought you were talking about plproxy ver.2

http://pgfoundry.org/projects/plproxy

all my ranting is about it, not pgpool II, which is indeed quite new
project ;)