Re: Background writer configuration

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: Background writer configuration
Дата
Msg-id 20060317172001.GA13758@uio.no
обсуждение исходный текст
Ответ на Re: Background writer configuration  (Steve Atkins <steve@blighty.com>)
Список 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 по дате отправления:

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Re: Background writer configuration
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: 1 TB of memory