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

Поиск
Список
Период
Сортировка
От Fernando Schapachnik
Тема Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1
Дата
Msg-id 199910221518.MAA20930@ns1.via-net-works.net.ar
обсуждение исходный текст
Ответ на Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1
Список pgsql-hackers
En un mensaje anterior, Tom Lane escribió:
> > I'm running postmaster -N 8 -B 16 because whitout these postmaster 
> > wouldn't get all the shared memory it needed and won't start. Do you 
> > think that this may be in some way related?
> 
> Well, that's certainly costing you performance; 16 disk pages is not
> enough buffer space to avoid thrashing.  You need to increase your
> kernel's max-shared-memory-block-size (SHMMAX, I think) parameter
> so that you can run with a more reasonable -B setting.  A lot of
> kernels ship with SHMMAX settings that are ridiculously small for
> any modern machine.

What value would you advise for shmmax?

Regards.


Fernando P. Schapachnik
Administración de la red
VIA Net Works Argentina SA
Diagonal Roque Sáenz Peña 971, 4º y 5º piso.
1035 - Capital Federal, Argentina. 
(54-11) 4323-3333
http://www.via-net-works.net.ar


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Planning final assault on query length limits