| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | "Narasimha Rao P(dot)A" <mtech_rao(at)yahoo(dot)co(dot)in> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: doubt |
| Date: | 2007-07-13 01:22:00 |
| Message-ID: | 20070713012200.GO4887@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* Narasimha Rao P.A (mtech_rao(at)yahoo(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2007-07-13 01:25:52 | Re: optimizing postgres |
| Previous Message | Stephen Frost | 2007-07-13 01:19:13 | Re: returns setof rec... simple exampe doesn't work |