Re: 64bits or 32 bits on ESX?

From: Adrian von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 64bits or 32 bits on ESX?
Date: 2010-01-21 13:06:38
Message-ID: 201001211406.42707@fortytwo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 21 January 2010 13.01:29 Magnus Hagander wrote:
> > 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 not in any way a performance expert, but IIRC 32 bit Linux has to use
some quirky logic (HIGHMEM) to address more than 2G physical memory, which
might reduce performance somewhat. So 2G is fine, but ...

Aside of memory: if performance is an issue, and assuming your db is bigger
than available memory: have you thought about the physical disk layout?
Having indices on different disks (physical disks matter, here!) from data,
splitting WAL from tablespaces etc. might all be much more important for
your performance than the 32bit vs. 64bit issue.

cheers
-- vbi

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Mitchell 2010-01-21 13:12:33 What locking mechanism is used for database backup and restore and Master-Slave Replication?
Previous Message Vincenzo Romano 2010-01-21 12:25:50 Re: 64bits or 32 bits on ESX?