Re: pg_stat_statements locking

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: pg_stat_statements locking
Дата
Msg-id 97FA14BC-3B93-41EA-92E8-DD62F66B422D@yandex-team.ru
обсуждение исходный текст
Ответ на Re: pg_stat_statements locking  (Julien Rouhaud <rjuju123@gmail.com>)
Ответы Re: pg_stat_statements locking
Список pgsql-hackers

> On 12 Sep 2022, at 18:18, Julien Rouhaud <rjuju123@gmail.com> wrote:
>
> That being
> said I don't know if adding a timeout would be too expensive for the lwlock
> infrastructure.

Implementation itself is straightforward, but we need to add 3 impls of waiting for semaphore with timeout.
POSIX have sem_timedwait(). Windows' WaitForMultipleObjectsEx() have timeout arg. SysV have semtimedop().
That's what we need to add something like LWLockAcquireWithTimeout().

Does adding all these stuff sound like a good tradeoff for lock-safe pg_stat_statements? If so - I'll start to
implementthis. 

Best regards, Andrey Borodin.


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