On Thu, 2006-12-21 at 16:54 -0600, Ron Johnson wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 12/21/06 16:41, Joshua D. Drake wrote: > >>>> 3) Put each customer in their own schema/namespace which resides within > >>>> its own table space. > >>>> > >>>> Then you can move customers wherever you need in terms of IO. > >> How is that functionally different than using a separate database? What's the > >> advantage here? I don't *need* to restrict myself to one database, and doing > >> this does require that I revisit 100% of the SQL queries to make sure that > >> I'm referencing the right schema. > >> > >> This solution seems to have the same problems as using dynamic tablenames. > > > > Not really. You should read up on schemas and how they work. Plus the > > addition of schemas and table spaces means you can infinite scaling > > within the confines of your hardware itself. > > "infinite scaling within the confines of your hardware"! > > How is that accomplished? Well with a tablespace, you can place the entire schema, easily on its own array. Say a nice little HP-MSA30. If that array gets tired you can add another array, and move a couple of schemas off to another array. Also if you spec the hardware correctly, you can get up to a total of 16 cores without any significant cost... just add cpus as needed. PostgreSQL 8.1 does extremely well up to 8 cpus (8 cores). 8.2 is said to perform better on > 8 cores, but I have not tested it. Sincerely, Joshua D. Drake > > - -- > Ron Johnson, Jr. > Jefferson LA USA > > Is "common sense" really valid? > For example, it is "common sense" to white-power racists that > whites are superior to blacks, and that those with brown skins > are mud people. > However, that "common sense" is obviously wrong. > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.6 (GNU/Linux) > > iD8DBQFFixCWS9HxQb37XmcRAnw/AJ4obPHIHvJcRKq1xzILN7YtKfQscACg1uaq > c6FRxkXjP/Pneyy1lxA+Dl8= > =iFX6 > -----END PGP SIGNATURE----- > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
