Skip site navigation (1) Skip section navigation (2)

clustering and denormalizing with PostgreSQL?

From: Chirag Patel <chirag(dot)patel(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: clustering and denormalizing with PostgreSQL?
Date: 2007-08-04 23:32:50
Message-ID: 958284.7524.qm@web52809.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
  My application is designed in such a way that the amount of data is expected to be enormous (in the terabytes). I would like to cluster the data and have the luxury of being able to slice up (denormalize) the database tables by user. In other words, users 1-50 and user 51-100 can be divided so that queries across users is not needed. 
   
  Does PostgresSQL or any third party add-ons allow this scaling to automatically occur? When I say automatically, I mean: 
  1.       New users are routed to a different database when the current database reaches a pre-defined capacity
  2.       Denormalization logic is provided so that the querying across databases is transparent to the user
   
  I’ve heard this feature described as “federation” or “horizontal scaling” in the O'Reilly book “Building Scalable Web Sites” 
   
  I’ve never done clustering  before so I’m clueless. Any ideas or better suggestions? 
   
  Thanks
  Chirag
  

Responses

pgsql-novice by date

Next:From: Sten Daniel SoersdalDate: 2007-08-06 02:02:30
Subject: Atomic/locked "allocation" of table row?
Previous:From: Chirag PatelDate: 2007-08-03 20:35:56
Subject: horizontal clustering?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group