Re: Splitting queries across servers

From: "Max" <maxdl(at)adelphia(dot)net>
To: "PgSql General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Splitting queries across servers
Date: 2005-01-29 18:20:39
Message-ID: CDEJIJMPHJJNHGFMBPBKIEPNFGAA.maxdl@adelphia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> > -----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.
>
> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2005-01-29 18:21:02 Re: Prompt User From a pgplsql Function
Previous Message Max 2005-01-29 18:04:20 Re: Splitting queries across servers