Re: PostgreSQL + 64 bit + performance

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: PostgreSQL + 64 bit + performance
Дата
Msg-id 2968dfd60909150825xb660ad8re71aee9b44f34397@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL + 64 bit + performance  (David Kerr <dmk@mr-paradox.net>)
Список 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 по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Non-check constraint def for a static list ?
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: altering domains, allowing null