Re: Splitting queries across servers

Поиск
Список
Период
Сортировка
От Max
Тема Re: Splitting queries across servers
Дата
Msg-id CDEJIJMPHJJNHGFMBPBKIEPLFGAA.maxdl@adelphia.net
обсуждение исходный текст
Ответ на Re: Splitting queries across servers  (William Yu <wyu@talisys.com>)
Список 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 по дате отправления:

Предыдущее
От: "Max"
Дата:
Сообщение: Re: Splitting queries across servers
Следующее
От: "Max"
Дата:
Сообщение: Re: Splitting queries across servers