From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Data partitioning? |
Date: | 2003-10-08 20:40:52 |
Message-ID: | 20031008204052.GP12185@libertyrms.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Oct 07, 2003 at 10:34:18AM +0100, psql-mail(at)freeuk(dot)com wrote:
> I am becoming more and more convinced that in order to achieve the
> required performance and scalability I need to split my data amoungst
> many backend machines.
How much data do you have, and what are you trying to run on? That
sounds like a _lot_. In any case, you can't do this in PostgreSQL
right now. A single back end controls all the data.
> I think this is called data partitioning in oracle?
Usually people mean spreading tables across different disks by some
criteria when they talk about that. Completely different machines is
pretty usual.
> If not what suggestions does anyone have for writing my own?
Be very careful. Multi-database concurrency problems are easy to
cause and hard to solve.
A
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2003-10-08 21:06:10 | Re: Replication Bundled with Main Source. |
Previous Message | Andrew Sullivan | 2003-10-08 20:33:56 | Re: Possible bug on insert |