Insert with Jsonb column hangs

From: kuldeep singh <kuldeeparora89(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Insert with Jsonb column hangs
Date: 2024-03-09 15:02:18
Message-ID: CAN-pzm0n_1fngEVOL5VvOmyLTaT3Bz1rQFzQiSkUf2ST9XeJPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,
KD

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hector vass 2024-03-09 15:16:55 Fwd: Getting error while upgrading
Previous Message hector vass 2024-03-09 14:56:07 Re: creating a subset DB efficiently ?