Re: Background writer configuration - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Background writer configuration
Date
Msg-id 20060317172001.GA13758@uio.no
Whole thread Raw
In response to Re: Background writer configuration  (Steve Atkins <steve@blighty.com>)
List pgsql-performance
On Fri, Mar 17, 2006 at 08:56:58AM -0800, Steve Atkins wrote:
> 64 bit binaries usually run marginally slower than 32 bit binaries.

This depends a bit on the application, and what you mean by "64 bit" (ie.
what architecture). Some specialized applications actually benefit from
having a 64-bit native data type (especially stuff working with a small
amount of bitfields -- think an anagram program), but Postgres is probably
not among them unless you do lots of arithmetic on bigints. amd64 has the
added benefit that you get twice as many registers available in 64-bit mode
(16 vs. 8 -- the benefit gets even bigger when you consider that a few of
those go to stack pointers etc.), so in some code you might get a few percent
extra from that, too.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Background writer configuration
Next
From: "Jim C. Nasby"
Date:
Subject: Re: 1 TB of memory