Re: Background writer configuration

From: Steinar H. Gunderson
Subject: Re: Background writer configuration
Date: ,
Msg-id: 20060317172001.GA13758@uio.no
(view: Whole thread, Raw)
In response to: Re: Background writer configuration  (Steve Atkins)
List: pgsql-performance

Tree view

Background writer configuration  ("Kevin Grittner", )
 Re: Background writer configuration  ("Joshua D. Drake", )
  Re: Background writer configuration  ("Kevin Grittner", )
 Re: Background writer configuration  (Evgeny Gridasov, )
  Re: Background writer configuration  ("Kevin Grittner", )
   Re: Background writer configuration  (Evgeny Gridasov, )
    Re: Background writer configuration  (PFC, )
     Re: Background writer configuration  (Evgeny Gridasov, )
      Re: Background writer configuration  (PFC, )
      Re: Background writer configuration  (11, )
       Re: Background writer configuration  (Evgeny Gridasov, )
    Re: Background writer configuration  ("Kevin Grittner", )
    Re: Background writer configuration  (Steve Atkins, )
     Re: Background writer configuration  ("Steinar H. Gunderson", )

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:

From: Tom Lane
Date:
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S
From: Scott Marlowe
Date:
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB &