Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.
Дата
Msg-id 20201118192743.kr43onoxci5gexjx@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-bugs
Дерево обсуждения 
Hi,

On 2020-11-18 11:57:05 +0100, Magnus Hagander wrote:
> This definitely sounds like something that's worth putting out as a
> wait event. Even before you start traversing millions of OIDs it might
> gradually start to show up, and being able to monitor that would
> definitely be useful.

I don't think this is likely to work well as a wait event. All the index
traversals etc will do IO, acquire locks, etc, which will overwrite the
wait event and reset it to nothing once done.

Greetings,

Andres Freund

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

Предыдущее
От: Jasmine Ng
Дата:
Сообщение: PostgreSQL 12.4 restore_command in postgresql.auto.conf
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16725: PG Admin 4 not loading due to Mime mistmatch