From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: Background writer configuration
Date: Fri, 17 Mar 2006 18:20:01 +0100
Message-ID: <20060317172001.GA13758@uio.no> (raw)
In-Reply-To: <6D84E9DE-E8AB-4C5D-8452-E141DBE9540D@blighty.com>
References: <44181A11.EE98.0025.0@wicourts.gov>
<20060316211523.73343cee.eugrid@fpm.kubsu.ru>
<44198B3D.EE98.0025.0@wicourts.gov>
<20060317152448.452e4854.eugrid@fpm.kubsu.ru>
<6D84E9DE-E8AB-4C5D-8452-E141DBE9540D@blighty.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgunderson@bigfoot.com
Subject: Re: Background writer configuration
In-Reply-To: <20060317172001.GA13758@uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox