Re: Splitting queries across servers - Mailing list pgsql-general

From Max
Subject Re: Splitting queries across servers
Date
Msg-id CDEJIJMPHJJNHGFMBPBKIEPLFGAA.maxdl@adelphia.net
Whole thread Raw
In response to Re: Splitting queries across servers  (William Yu <wyu@talisys.com>)
List pgsql-general

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of William Yu
> Sent: Friday, January 28, 2005 11:36 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
> Without memory, the prices are roughly:
>
> 4x846 = $5500
> 4x848 = $6500
> 4x850 = $8000
>
> Memory costs would be:
>
> 16GB (1GB DIMMs) = $3000
> 32GB (2GB DIMMs) = $7500
> 64GB (4GB DIMMs) = $24000
> 128GB (8GB DIMMs) = $60000
>
> The prices on the 4GB & 8GB DIMMs are bleeding edge of course. I see a
> wide range of for them on Froogle. You will want your vendor of course
> to pick memory is proper for the MB and pay whatever premium they'll
> charge ontop of it. (Looking at the Tyan website, they only list 2GB
> DIMMs as supported for their Quad Opteron MBs but whether that's because
> those specs were done before >= 4GB DIMMs were available or an actual
> hardware limitation, I dunno.)
>

Thank you! That's very thorough. hm... we're talking 35K then. That could be
in my budget.

>
>
>
> Max wrote:
> >>
> >>With a Quad Opteron (4 memory slots per CPU), you could put 64GB of RAM
> >>onto a single machine using 4GB DIMMs in every slot.
> >
> >
> > We were talking about a similar solution today, but not quite as good as
> > this. You really got me thinking now. 64Gb.. hm that would solve many
> > issues. what do you think the cost would be for such a beast ?
> Any idea ?
> >
> > Max
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



pgsql-general by date:

Previous
From: "Max"
Date:
Subject: Re: Splitting queries across servers
Next
From: "Max"
Date:
Subject: Re: Splitting queries across servers