Home > mailing lists

Insert with Jsonb column hangs - Mailing list pgsql-general

From	kuldeep singh
Subject	Insert with Jsonb column hangs
Date	March 9 18:02:18
Msg-id	CAN-pzm0n_1fngEVOL5VvOmyLTaT3Bz1rQFzQiSkUf2ST9XeJPQ@mail.gmail.com Whole thread Raw
Responses	Re: Insert with Jsonb column hangs (hector vass <hector.vass@gmail.com>)
List	pgsql-general

Hi,

We are inserting data close to 1M record & having a single Jsonb column but query is getting stuck.

We are using insert into select * .. , so all the operations are within the DB.

If we are running select query individually then it is returning the data in 40 sec for all rows but with insert it is getting stuck.

PG Version - 15.

What could be the problem here ?

Regards,

From: hector vass
Date: 09 March, 17:56:07
Subject: Re: creating a subset DB efficiently ?

From: hector vass
Date: 09 March, 18:16:55
Subject: Fwd: Getting error while upgrading