Re: [HACKERS] Broken O(n^2) avoidance in wal segment recycling.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] Broken O(n^2) avoidance in wal segment recycling.
Дата
Msg-id 20190507024505.w53vdqywbq52jxp2@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] Broken O(n^2) avoidance in wal segment recycling.  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: [HACKERS] Broken O(n^2) avoidance in wal segment recycling.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] Broken O(n^2) avoidance in wal segment recycling.  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-hackers
Hi,

I just hit this bad a couple times during some testing. Under load, with
2500 segments to recycle, it took well over a minute.

I think we ought to backpatch a version of this fix. Yes, there've not
been many complaints, but there's no messages during log levels one can
enable without beeing completely flooded, so I don't think it's every
likely to be debugged on a live system.

Noteworth is that this stall due to the O(n^2) happens while holding
ControlFileLock.

I'm inclined to think we should even backpatch this.

Heikki, Michael, any comment?

- Andres



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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: [PATCH v1] Add a way to supply stdin to TAP tests
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Broken O(n^2) avoidance in wal segment recycling.