RE: Timeout parameters

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема RE: Timeout parameters
Дата
Msg-id 0A3221C70F24FB45833433255569204D1FBC7626@G01JPEXMBYT05
обсуждение исходный текст
Ответ на RE: Timeout parameters  (MikalaiKeida@ibagroup.eu)
Ответы Re: Timeout parameters
RE: Timeout parameters
Список pgsql-hackers
From: MikalaiKeida@ibagroup.eu [mailto:MikalaiKeida@ibagroup.eu]
> > For example, OS issues such as abnormally (buggy) slow process scheduling
> or paging/swapping that prevent control from being passed to postgres.  Or,
> abnormally long waits on lwlocks in postgres.  statement_timeout doesn't
> take effect while waiting on a lwlock.  I have experienced both.  And, any
> other issues in the server that we haven't experienced and not predictable.
> 
> For me all mentioned by Takayuki Tsunakawa problems looks like a lack of
> design of end-user application or configuration of DB server. It is not
> a problem of PostgreSQL.

Certainly, my cases could be avoided by the OS and database configuration.  But we cannot say all such problems can be
avoidedby configuration in advance.  The point is to provide a method to get ready for any situation.
 


Regards
Takayuki Tsunakawa






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

Предыдущее
От: MikalaiKeida@ibagroup.eu
Дата:
Сообщение: RE: Timeout parameters
Следующее
От: David Rowley
Дата:
Сообщение: Re: Inadequate executor locking of indexes