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