By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,693 Members | 1,972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,693 IT Pros & Developers. It's quick & easy.

Data partitioning?

P: n/a
hi,

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.

Ideally I would start with about 10 machine and have 1/10th of the data
on each. As the data set grows I would then buy additional machines to
spread the data over.

I think this is called data partitioning in oracle?
What does postgresql have to offer in this area?

Does software already exist to query multiple identical schemas each
with different data stored in them, and then correlate the results?

If not what suggestions does anyone have for writing my own?

Thanks,
Mat

--

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, Oct 07, 2003 at 10:34:18AM +0100, ps*******@freeuk.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
<an****@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.