Thanks Adrian & Hector .
I will try the copy approach & post the result here.
On Sat, Mar 9, 2024 at 9:57 PM hector vass wrote:
>
>
> On Sat, Mar 9, 2024 at 4:10 PM Adrian Klaver
> wrote:
>
>> On 3/9/24 08:00, kuldeep singh wrote:
>> > Copy may not work
a in its individual transactions? Or any other better
solution available ?
On Sat, Mar 9, 2024 at 9:01 PM hector vass wrote:
>
>
> On Sat, Mar 9, 2024 at 3:02 PM kuldeep singh
> wrote:
>
>> Hi,
>>
>> We are inserting data close to 1M record & having a sing
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