Thread: doubt

doubt

From
"Narasimha Rao P.A"
Date:
Does postgreSQL support distributive query processing?


5, 50, 500, 5000. Store N number of mails in your inbox. Click here.

Re: doubt

From
Stephen Frost
Date:
* 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