Re: Partitioning Vs. Split Databases - performance? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Partitioning Vs. Split Databases - performance?
Date
Msg-id 1166746321.5594.58.camel@localhost.localdomain
Whole thread Raw
In response to Re: Partitioning Vs. Split Databases - performance?  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Partitioning Vs. Split Databases - performance?
Re: Partitioning Vs. Split Databases - performance?
List pgsql-general
> >> 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




pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Partitioning Vs. Split Databases - performance?
Next
From: "Magiclouds Magicloud"
Date:
Subject: How could I get a win32/aix version of plruby?