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

From Mike Rylander
Subject Re: Splitting queries across servers
Date
Msg-id b918cf3d05012911007fa23291@mail.gmail.com
Whole thread Raw
In response to Re: Splitting queries across servers  ("Max" <maxdl@adelphia.net>)
Responses Re: Splitting queries across servers  ("Max" <maxdl@adelphia.net>)
List pgsql-general
On Sat, 29 Jan 2005 09:55:15 -0800, Max <maxdl@adelphia.net> wrote:
>
>
> > -----Original Message-----
> > From: pgsql-general-owner@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.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@adelphia.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@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org

pgsql-general by date:

Previous
From: Ragnar Hafstað
Date:
Subject: Re: Prompt User From a pgplsql Function
Next
From: Terry Lee Tucker
Date:
Subject: Re: Prompt User From a pgplsql Function