| From: | "Max" <maxdl(at)adelphia(dot)net> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Splitting queries across servers |
| Date: | 2005-01-29 17:57:48 |
| Message-ID: | CDEJIJMPHJJNHGFMBPBKIEPLFGAA.maxdl@adelphia.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of William Yu
> Sent: Friday, January 28, 2005 11:36 AM
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Max | 2005-01-29 18:04:20 | Re: Splitting queries across servers |
| Previous Message | Max | 2005-01-29 17:55:15 | Re: Splitting queries across servers |