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

From Max
Subject Re: Splitting queries across servers
Date
Msg-id CDEJIJMPHJJNHGFMBPBKIEPNFGAA.maxdl@adelphia.net
Whole thread Raw
In response to Re: Splitting queries across servers  ("Max" <maxdl@adelphia.net>)
List pgsql-general
>
> > -----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.
>
> What OS are you running on your quad opteron ?
>
> Anyone's run some postgres performance tests between two machines same
> config different OS ?
>
> Max
>

I want to mention that this last question is not invitation to flame about
windows against linux ;)
Personal preferences set aside, I am looking at performance consideration.

thanks!

Max



pgsql-general by date:

Previous
From: "Max"
Date:
Subject: Re: Splitting queries across servers
Next
From: Terry Lee Tucker
Date:
Subject: Re: Prompt User From a pgplsql Function