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)
Список
Дерево обсуждения
BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. PG Bug reporting form <noreply@postgresql.org>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. Fujii Masao <masao.fujii@oss.nttdata.com>
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. Andres Freund <andres@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. Andres Freund <andres@anarazel.de>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. Andres Freund <andres@anarazel.de>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. Andres Freund <andres@anarazel.de>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. Sergey KOPOSOV <Sergey.Koposov@ed.ac.uk>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. tomohiro hiramitsu <hiramit.tm@gmail.com>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. Kasahara Tatsuhito <kasahara.tatsuhito@gmail.com>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. tomohiro hiramitsu <hiramit.tm@gmail.com>
Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table. Kasahara Tatsuhito <kasahara.tatsuhito@gmail.com> 
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
Дата:
Следующее
От: PG Bug reporting form
Дата:
FAQ