Re: Postgresql performance on Solaris

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Postgresql performance on Solaris
Дата
Msg-id Pine.LNX.4.33.0304011441550.15613-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Postgresql performance on Solaris  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Tue, 1 Apr 2003, Tom Lane wrote:

> The only other idea I can think of is that there's some weird effect in
> the locking code (which only shows up with lots of concurrent backends)
> such that would-be lockers repeatedly fail and sleep when they should
> have gotten the lock.  If you can figure out how to tell the difference
> between a backend waiting for disk I/O and one waiting for a semaphore
> or sleeping, it'd be interesting to see what the majority of the
> backends are doing.

I was thinking along the lines of it being something like the old Linux
kernel had with apache and other programs with waking all the processes.
It could be that something about Solaris is meaning that every backend
process, no matter how idle they are, get "touched" every time something
is done.  Just guessing.


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

Предыдущее
От: "Keith Bottner"
Дата:
Сообщение: Re: ext3 filesystem / linux 7.3
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: ext3 filesystem / linux 7.3