Re: 64bits or 32 bits on ESX? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: 64bits or 32 bits on ESX?
Date
Msg-id 20100121131142.00000ec1@iso-8859-1
Whole thread Raw
In response to Re: 64bits or 32 bits on ESX?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
On Thu, 21 Jan 2010 13:01:29 +0100
Magnus Hagander <magnus@hagander.net> wrote:

> On Thu, Jan 21, 2010 at 12:45, A. Kretschmer
> <andreas.kretschmer@schollglas.com> wrote:
> > In response to Magnus Hagander :
> >> 2010/1/21 Bjørn T Johansen <btj@havleik.no>:
> >> > We are going to be setting up a PostgreSQL server on a guest under VMWare ESX 4... Is there any performance
improvementby choosing 64bits 
> >> > Linux over 32bits Linux as the guest OS or is it almost the same?
> >>
> >> How much resources do you plan to give the machine?
> >>
> >> If you're setting up a very constrained machine with little memory, go
> >> with the 32-bit version. It'll use slightly less memory which can be
> >> important if you're constrained.
> >>
> >> If you're setting up a medium size or bigger machine (2Gb+ memory),
> >> use a 64-bit version. If you plan you may eventually need to increase
> >
> > Really? With ONLY 2Gb? Why? What is the performance improvement, with
> > 64Bit all pointers and so on needs more memory so i'm expecting lesser
> > memory for the data.
> >
> > I'm wrong?
>
> While the theoretical limit is a bit higher, the fact that you have to
> reinstall once you've realized you wanted to add a little bit more
> memory.... More important to me at least :-)
>

I also thought that the fact the 64bit system can move more data in parallell would also make the system faster....

BTJ


pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: PgSQL problem: How to split strings into rows
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: PgSQL problem: How to split strings into rows