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

From William Yu
Subject Re: Splitting queries across servers
Date
Msg-id cte47h$2mm4$1@news.hub.org
Whole thread Raw
In response to Re: Splitting queries across servers  ("Max" <maxdl@adelphia.net>)
Responses Re: Splitting queries across servers
List pgsql-general
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.)




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
>

pgsql-general by date:

Previous
From: Pailloncy Jean-Gerard
Date:
Subject: Re: Extended unit
Next
From: "Jim C. Nasby"
Date:
Subject: Re: changing sort_mem on the fly?