Re: Partitioning Vs. Split Databases - performance?

> >> 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