Re: Tuning shared_buffers with ipcs ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Tuning shared_buffers with ipcs ?
Дата
Msg-id 10905.1097862665@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Tuning shared_buffers with ipcs ?  (Doug Y <dylists@ptd.net>)
Ответы Re: Tuning shared_buffers with ipcs ?  (Doug Y <dylists@ptd.net>)
Список pgsql-performance
Doug Y <dylists@ptd.net> writes:
> I've seen a couple references to using ipcs to help properly size
> shared_buffers.

I have not seen any such claim, and I do not see any way offhand that
ipcs could help.

> I tried all of the dash commands in the ipcs man page, and the only one
> that might give a clue is ipcs -t which shows the time the semaphores
> were last used. If you look at the example I give below, it appears as
> if I'm only using 4 of the 17 semaphores (PG was started on Oct 8).

This might tell you something about how many concurrent backends you've
used, but nothing about how many shared buffers you need.

            regards, tom lane

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

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Re: Does PostgreSQL run with Oracle?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin