Re: Migrate postgres to newer hardware - Mailing list pgsql-admin

From Tom Lane
Subject Re: Migrate postgres to newer hardware
Date
Msg-id 19069.1269962152@sss.pgh.pa.us
Whole thread Raw
In response to Re: Migrate postgres to newer hardware  (Renato Oliveira <renato.oliveira@grant.co.uk>)
List pgsql-admin
Renato Oliveira <renato.oliveira@grant.co.uk> writes:
> If I use postgres 32 bit will it benefit from the extra memory on the system?

Yes, although perhaps not as much as you'd get with a 64-bit build.
You still get the ability to have more than 4GB worth of kernel-managed
disk cache, and in many situations that's all the value of a 64-bit
machine anyway.  You can find lots and lots about that in the
pgsql-performance archives.

            regards, tom lane

pgsql-admin by date:

Previous
From: jose javier parra sanchez
Date:
Subject: Re: Migrate postgres to newer hardware
Next
From: Rosser Schwarz
Date:
Subject: Re: Migrate postgres to newer hardware