Re: PostgreSQL, OLAP, and Large Clusters
| От | Chris Travers |
|---|---|
| Тема | Re: PostgreSQL, OLAP, and Large Clusters |
| Дата | |
| Msg-id | CAKt_ZfuN+RkVuhWs0pBE=fFJtbJRW4hg6he-dhoiZOq0T3+C+w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PostgreSQL, OLAP, and Large Clusters (Ryan Kelly <rpkelly22@gmail.com>) |
| Список | pgsql-general |
On Thu, Sep 27, 2012 at 11:34 AM, Ryan Kelly <rpkelly22@gmail.com> wrote:
From what I understand, more of a write-scaleable-oriented solution. We
> At this time I would try:
> - Postgres-XC
mostly will need read scalability. I also don't think it really handles
redundancy.
From my understanding it gets around the key read scalability issue in PostgreSQL, which is a lack of intraquery parallelism. Since components of a query can run on different storage nodes concurrently, this helps a great deal. It doesn't do the things a column store would help with but it is still a major step forward.
As for redundancy, Postgres-XC handles redundancy on the coordinator side, but on the storage node side, I believe you could use streaming replication and other standard PostgreSQL approaches to redundancy there.
Hope this helps,
Chris Travers
В списке pgsql-general по дате отправления: