> >> 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. > > Sure, but *infinite*? Or were you exercising hyperbole? I did say, infinite with the *confines* of the hardware :) > > With One Big Database, you can get a SAN and attach a whole lot of > disk space, but your mobo will only accept a certain number of DIMMs > and processors of certain designs. And when your growing mega > database maxes out your h/w, you're stuck. Define mega... Because you would need to be in the multi-terrabyte range. 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) > > iD8DBQFFixgDS9HxQb37XmcRAm5TAKCVGpWvb9SKB+Kk44J/88WTEhnYoQCeKgcd > BhorUjImDd+SldObdWuhFjw= > =lSm5 > -----END PGP SIGNATURE----- > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- === 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