Re: doubt - Mailing list pgsql-general

From Stephen Frost
Subject Re: doubt
Date
Msg-id 20070713012200.GO4887@tamriel.snowman.net
Whole thread Raw
In response to doubt  ("Narasimha Rao P.A" <mtech_rao@yahoo.co.in>)
List pgsql-general
* Narasimha Rao P.A (mtech_rao@yahoo.co.in) wrote:
> Does postgreSQL support distributive query processing?

PostgreSQL does not directly support splitting one query across multiple
nodes (cpus, machines, whatever).  It's certainly possible to set up
distributed load balancing over some set of PostgreSQL instances with
things like read-only slaves and whatnot.  Also, of course, PostgreSQL
can handle lots of and lots of seperate queries simultaneously with good
scalability.  You can also partition your data across systems and
basically write application stuff to handle doing aggregated queries on
each and then merging them together, etc...

    Stephen

Attachment

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: returns setof rec... simple exampe doesn't work
Next
From: Stephen Frost
Date:
Subject: Re: optimizing postgres