Re: PHP and PostgreSQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PHP and PostgreSQL
Дата
Msg-id 11150.978411596@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: PHP and PostgreSQL  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Now what happens is if someone browses the phorums for a little while, and
> then switches to pages that use our own db classes, you get random slowdowns
> (ie. a select occurs, and then times out after 2 mins or so).
> If you use psql, and perform the select you get a 'shared memory corruption'
> and 'timed out waiting for lock' errors.

Ugh.  We would like to think that client misbehavior couldn't cause such
things.  Can you dig into this some more, and provide further details on
what is happening and what the sequence of client requests is?
        regards, tom lane


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

Предыдущее
От: "Patrick Dunford"
Дата:
Сообщение: Ignored PostgreSQL SET command
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Current Sources/UW7.1.1