Re: Moving from 32 to 64 bit builds on Solaris

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dan Sugalski <dan(at)sidhe(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving from 32 to 64 bit builds on Solaris
Date: 2007-03-10 06:01:27
Message-ID: 8082.1173506487@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dan Sugalski <dan(at)sidhe(dot)org> writes:
> I assume I'll have to do a 64 bit build to use more than a few gig of
> shared buffers. If I do that, though, am I going to have to do a
> database dump and reload,

Yes, most likely, because you'll have changed MAXALIGN and therefore the
data alignment rules.

You should first ask yourself whether you will get any performance
benefit from having "more than a few gig of shared buffers". If anyone
has proven such a benefit I haven't seen it.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Berglund 2007-03-10 06:24:04 Re: Is This A Set Based Solution?
Previous Message Tom Lane 2007-03-10 05:42:46 Re: query ... returned 4 columns