From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | "Timasmith" <timasmith(at)hotmail(dot)com> |
Subject: | Re: postgresql roadmap for horizontal scalability? |
Date: | 2006-12-03 19:47:31 |
Message-ID: | 200612031147.31699.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Timasmith,
> This database has exceeded all expectations and perhaps I am getting
> ahead of myself but is there anything in the roadmap to match Oracles
> ability to cluster databases across multiple servers for concurrent
> access?
There are several efforts to do *better than* RAC, which is actually not very
effective (RAC scales very poorly, and not at all for some applications).
These include pgPool, Skytools, pgCluster, Replicator, Postgres-R and
Sequoia.
> The reason I ask is for the architecture of an open source database
> project I am working on. It is tempting to ignore caching altogether
> and push the onus on to the database to perform more database queries.
> This is makes life easier and allows the focus to be on the business
> logic.
Yes, except even on a clustered system proper use of caching will *always* at
least double database peformance. There's simply no way to make an ACID
RDBMS anywhere near as fast as a simple thing like a cache.
> However if Postgresql is the datababase and the only means to scale is
> to buy a bigger single server then that could become a problem of cost
> to the community. It would be cheaper to scale across multiple smaller
> servers (I think).
Yes, it would. However, scalable OLTP clustering is a problem not yet solved
by anyone in the industry. It may not be solvable at all.
> The application I am working on is OLTP with say 90% reads to writes
> ratio.
Hmmm ... that makes it more like web than OLTP. You may be able to use a
query replication system like pgPool or Sequoia.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2006-12-03 19:50:13 | Re: Problems to create the portuguese dictionary |
Previous Message | Bruce Momjian | 2006-12-03 16:57:06 | Re: [HACKERS] Case Preservation disregarding case |