On Dec 7, 2007, at 11:53 AM, Robert Treat wrote:
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)
Yeah, when I get to that point I'll definitely be testing with that
as that will definitely make things simpler from the application's
perspective. First I have to fix our current schema though :(
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
