Re: PostgreSQL and Xeon MP

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL and Xeon MP
Дата
Msg-id 17483.1142526898@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL and Xeon MP  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Ответы Re: PostgreSQL and Xeon MP  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-performance
"Guillaume Smet" <guillaume.smet@gmail.com> writes:
> You mean strace -p pid with pid on some of the postgres process not on
> the postmaster itself, does you?

Right, pick a couple that are accumulating CPU time.

> Do we need other options?

strace will generate a *whole lot* of output to stderr.  I usually do
something like
    strace -p pid 2>outfile
and then control-C it after a few seconds.

> Which pattern should we expect?

What we want to find out is if there's a lot of select()s and/or
semop()s shown in the result.  Ideally there wouldn't be any, but
I fear that's not what you'll find.

            regards, tom lane

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

Предыдущее
От: "Guillaume Smet"
Дата:
Сообщение: Re: PostgreSQL and Xeon MP
Следующее
От: Sven Geisler
Дата:
Сообщение: Re: PostgreSQL and Xeon MP