Search Postgresql Archives

Re: Splitting queries across servers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> -----Original Message-----
> From: pgsql-general-owner@xxxxxxxxxxxxxx
> [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of William Yu
> Sent: Friday, January 28, 2005 11:36 AM
> To: pgsql-general@xxxxxxxxxxxxxx
> Subject: Re:  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@xxxxxxxxxxxxxx)
>



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux