Обсуждение: doubt

Поиск
Список
Период
Сортировка

doubt

От
"Narasimha Rao P.A"
Дата:
Does postgreSQL support distributive query processing?


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

Re: doubt

От
Stephen Frost
Дата:
* 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

Вложения