Re: INSERTS waiting with wait_event is "transactionid"

2021-04-09 Thread Nagaraj Raj
Hi Laurenz, Thanks for the response.  Yeah understand that, but I'm trying to figure out why it is taking too long. there is foreign key relation to this table.  Thanks,RjOn Friday, April 9, 2021, 02:16:08 AM PDT, Laurenz Albe wrote: On Thu, 2021-04-08 at 20:14 +, Nagaraj Raj wrot

Re: INSERTS waiting with wait_event is "transactionid"

2021-04-09 Thread Laurenz Albe
On Thu, 2021-04-08 at 20:14 +, Nagaraj Raj wrote: > We are trying to load data around 1Bil records into one table with INSERT > statements > (not able to use COPY command) and they are been waiting for a lock and the > wait_event > is "transactionid", I didn't find any information in the do

INSERTS waiting with wait_event is "transactionid"

2021-04-08 Thread Nagaraj Raj
Hi, We are trying to load data around 1Bil records into one table with INSERT statements (not able to use COPY command) and they are been waiting for a lock and the wait_event is "transactionid", I didn't find any information in the documents. Queries have been waiting for hours. Table DDL'sCREA