Re: Six PostgreSQL questions from a pokerplayer

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Six PostgreSQL questions from a pokerplayer
Дата
Msg-id 1246942274.26636.318.camel@tillium.localnet
обсуждение исходный текст
Ответ на Re: Six PostgreSQL questions from a pokerplayer  (Mark Mielke <mark@mark.mielke.cc>)
Ответы Re: Six PostgreSQL questions from a pokerplayer  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
On Mon, 2009-07-06 at 15:27 -0400, Mark Mielke wrote:

> Even if you only have 4 GB of RAM, the 32-bit kernel needs to fight
> with "low memory" vs "high memory", whereas 64-bit has a clean address
> space.

That's a good point. The cutoff is probably closer to 2G or at most 3G.
Certainly it's madness to use hacks like PAE to gain access to the RAM
behind the PCI address space rather than just going 64-bit ... unless
you have a really pressing reason, at least.

It's also nice that on a 64 bit machine, there's no 2G/2G or 3G/1G
userspace/kernelspace address mapping split to limit your app's memory
use. I seem to recall that Windows uses 2G/2G which can be painfully
limiting for memory-hungry applications.

Personally, I'd probably go 64-bit on any reasonably modern machine that
could be expected to have more than 2 or 3 GB of RAM. Then again, I
can't imagine willingly building a production database server for any
non-trivial (ie > a couple of gigs) database with less than 8GB of RAM
with RAM prices so absurdly low. Skip-lunch-to-afford-more-RAM low.

--
Craig Ringer


В списке pgsql-performance по дате отправления:

Предыдущее
От: justin
Дата:
Сообщение: Re: Bundling postgreSQL with my Java application
Следующее
От: Saurabh Dave
Дата:
Сообщение: Re: Bundling postgreSQL with my Java application