Re: Splitting queries across servers

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Mike Rylander
> Sent: Saturday, January 29, 2005 11:01 AM
> To: Max
> Cc: PgSql General
> Subject: Re: [GENERAL] Splitting queries across servers
>
>
> 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...
>

Actually winXP and win server 2003 do support AMD64, it's intel 64 that's
not supported yet.

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

Thanks for reminding me that 64bit translates to: recompile everything you
need!

I think this is exactly the choice of configuration we are going to make.
Someone just reminded me that windows and linux come down to the same
performance, but that the real overhead is on maintenance. It's true that
linux implies less downtime, and you can always upgrade. On top of that,
there's more granularity control on linux.

Thanks for the info.

Max

>
>
> --
> Mike Rylander
> mrylander@gmail.com
> GPLS -- PINES Development
> Database Developer
> http://open-ils.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>