Re: PostgreSQL + 64 bit + performance - Mailing list pgsql-general

From Vick Khera
Subject Re: PostgreSQL + 64 bit + performance
Date
Msg-id 2968dfd60909150825xb660ad8re71aee9b44f34397@mail.gmail.com
Whole thread Raw
In response to PostgreSQL + 64 bit + performance  (David Kerr <dmk@mr-paradox.net>)
List pgsql-general
On Mon, Sep 14, 2009 at 7:13 PM, David Kerr <dmk@mr-paradox.net> wrote:
> My oracle experience tells me that I want to go with 64 bit postgres
> so that i can have faster disk and memory access.

If not faster memory access, but you can get more memory in a 64-bit
address space.  My primary DB servers have 24GB of RAM.

Also, the amd 64-bit extensions to the intel instruction set increase
the number of CPU registers which allows for some better code
optimizations and reduced hits on RAM.  But that may not be that great
a benefit as it may seem on the surface.  I have not benchmarked this.

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Non-check constraint def for a static list ?
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: altering domains, allowing null