On Wednesday 05 December 2007 17:29, Erik Jones wrote:
> > i dont think you'll have much luck taking the "spread data evenly
> > throught the
> > partitions" approach; figure out how best to segment your data into
> > manageable chunks. HTH.
>
> I agree. That's also why I'm not too worried about taking a bin
> based approach to the partitioning. In addition, once this is done,
> however I end up doing it, I'm going to be working on a horizontal
> systems scaling approach wherein I set up another database, replicate
> the global tables (all 132 of them) to it, and split the accounts'
> userdata between the two databases -- fun, fun, fun!
>
A few of us have been playing with using plproxy in partitioning triggers to
also achieve horizontal scaling at the same time, you might want to look into
that. (Personally I've not yet landed a customer who needs such a solution,
but hopefully soon)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
