Re: Splitting queries across servers

On Sat, 29 Jan 2005 09:55:15 -0800, Max <maxdl(at)adelphia(dot)net> wrote:
>
>
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org
> > [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Mike Rylander
> > Sent: Friday, January 28, 2005 4:02 AM
> > To: Max; PgSql General
> > Subject: Re: [GENERAL] Splitting queries across servers
> >
> >
> > On Thu, 27 Jan 2005 20:17:29 -0800, Max <maxdl(at)adelphia(dot)net> 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 ?
> >
> > Depending on the vendor and the storage subsystem, between $20k and
> > $50k, and if you start with less memory it will be much less. I can
> > attest to the fact that 4 x Opterons work VERY nicely. ;)
> >
>
> Thanks.
>
> That would be quite an investment. Interesting. I wonder if we should put
> windows or linux on it, since postgresql 8.0 works on windows.

To the best of my knowledge there is no 64-bit Windows for AMD64, but
I've not been forced to use Windows in 5 or 6 years...

>
> What OS are you running on your quad opteron ?

We are using the x86-64 build of Gentoo Linux and compiling our own
copy of PG 8.0.

--
Mike Rylander
mrylander(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org