Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1

Поиск
Список
Период
Сортировка
От Brian E Gallew
Тема Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1
Дата
Msg-id emacs-smtp-11255-14352-35159-445918@export.andrew.cmu.edu
обсуждение исходный текст
Ответ на Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Then <tgl@sss.pgh.pa.us> spoke up and said:
> Fernando Schapachnik <fpscha@ns1.via-net-works.net.ar> writes:
> > What value would you advise for shmmax?
> 
> more than the default number of buffers.  But I have no advice on
> how many is appropriate for what size of installation --- can anyone
> else help?

Unless you are severely resource constrained, think big.  Generally
speaking, the kilobytes of memory you'll lose to kernel structures are
irrelevant.  Performance is generally not an issue, either.

-- 
=====================================================================
| JAVA must have been developed in the wilds of West Virginia.      |
| After all, why else would it support only single inheritance??    |
=====================================================================
| Finger geek@cmu.edu for my public key.                            |
=====================================================================

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1
Следующее
От: Tom Lane
Дата:
Сообщение: Current sources fail if two 'serial' columns in one table