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

From Andres Freund
Subject Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.
Date
Msg-id 20201118192743.kr43onoxci5gexjx@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.  (Magnus Hagander <magnus@hagander.net>)
Responses Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.
List 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 by date:

Previous
From: Jasmine Ng
Date:
Subject: PostgreSQL 12.4 restore_command in postgresql.auto.conf
Next
From: PG Bug reporting form
Date:
Subject: BUG #16725: PG Admin 4 not loading due to Mime mistmatch