Re: [GENERAL] Re-partitioning huge schema

2007-12-07 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 07 Dec 2007 12:53:45 -0500 Robert Treat <[EMAIL PROTECTED]> 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;

Re: [GENERAL] Re-partitioning huge schema

2007-12-07 Thread Erik Jones
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

Re: [GENERAL] Re-partitioning huge schema

2007-12-07 Thread Robert Treat
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

Re: [GENERAL] Re-partitioning huge schema

2007-12-05 Thread Erik Jones
Rober, Thank you once again for your input. On Dec 5, 2007, at 3:23 PM, Robert Treat wrote: On Monday 03 December 2007 17:32, Erik Jones wrote: Too much to keep quoted here. Check the archives if you want to read more about the setup for this conversation. -[ RECORD 1 ]+

Re: [GENERAL] Re-partitioning huge schema

2007-12-05 Thread Robert Treat
On Monday 03 December 2007 17:32, Erik Jones wrote: > Hi, I've inherited a database schema wherein the original > developers took the inheritance mechanism to an extreme where new > client accounts get 13 different tables of their own created for > them. We're at the many tens of thousands of tab

[GENERAL] Re-partitioning huge schema

2007-12-03 Thread Erik Jones
Hi, I've inherited a database schema wherein the original developers took the inheritance mechanism to an extreme where new client accounts get 13 different tables of their own created for them. We're at the many tens of thousands of tables mark (well over 100K) and I'm going to be re-par