Re: Disconnects hanging server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Disconnects hanging server
Дата
Msg-id 16153.1196959017@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Disconnects hanging server  (Brian Wipf <brian@clickspace.com>)
Список pgsql-general
Brian Wipf <brian@clickspace.com> writes:
> Nearly 100% of the CPU is going into pmap_remove_range. The stack
> trace for pmap_remove_range, viewable within Shark, is:
> -> pmap_remove_range
> --> pmap_remove
> ---> vm_map_simplify
> ----> vm_map_remove
> -----> task_terminate_internal
> ------> exit1
> -------> exit
> --------> unix_syscall64
> ---------> lo64_unix_scall

In case it's not obvious, this is a kernel performance bug, which
you should report to Apple.

In the meantime you might want to think about backing off your
shared_buffers setting.  I would suppose that the performance bug
is being triggered by a very large shared memory segment (you
said 3Gb right?).

            regards, tom lane

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

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: pg_dump and server responsiveness
Следующее
От: Henrik
Дата:
Сообщение: Re: Unreasonable size of table pg 8.2.5