Re: Importing a Large .ndjson file - Mailing list pgsql-general

From Sankar P
Subject Re: Importing a Large .ndjson file
Date
Msg-id CAMSEaH7Vkh3JfwjJfFjQH-UtjEf71aSgA0aEEjqpE42MnLUYcQ@mail.gmail.com
Whole thread Raw
In response to Re: Importing a Large .ndjson file  (Sankar P <sankar.curiosity@gmail.com>)
Responses Re: Importing a Large .ndjson file  (Michael Lewis <mlewis@entrata.com>)
Re: Importing a Large .ndjson file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> > It looks like plain old COPY would do this just fine, along the lines
> > of (in psql)
> >
> > \copy myTable(content) from 'myfile.ndjson'

I spoke too soon. While this worked fine when there were no indexes
and finished within 10 minutes, with GIN index on the jsonb column, it
is taking hours and still not completing.

-- 
Sankar P
http://psankar.blogspot.com



pgsql-general by date:

Previous
From: Michel Pelletier
Date:
Subject: Re: Hiding a GUC from SQL
Next
From: Michael Lewis
Date:
Subject: Re: Importing a Large .ndjson file