Re: Issue with the PRNG used by Postgres

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Issue with the PRNG used by Postgres
Дата
Msg-id 20240409210521.dwcjdobnwkyjbars@awork3.anarazel.de
обсуждение исходный текст
Ответ на [MASSMAIL]Issue with the PRNG used by Postgres  (Parag Paul <parag.paul@gmail.com>)
Ответы Re: Issue with the PRNG used by Postgres
Re: Issue with the PRNG used by Postgres
Список pgsql-hackers
Hi,

On 2024-04-08 22:52:09 -0700, Parag Paul wrote:
>  We have an interesting problem, where PG went to PANIC due to stuck
> spinlock case.
> On careful analysis and hours of trying to reproduce this(something that
> showed up in production after almost 2 weeks of stress run), I did some
> statistical analysis on the RNG generator that PG uses to create the
> backoff for the spin locks.

ISTM that the fix here is to not use a spinlock for whatever the contention is
on, rather than improve the RNG.

Greetings,

Andres Freund



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: post-freeze damage control
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PostgreSQL 17 Release Management Team & Feature Freeze