Re: Importing a Large .ndjson file

Поиск
Список
Период
Сортировка
От Sankar P
Тема Re: Importing a Large .ndjson file
Дата
Msg-id CAMSEaH7Vkh3JfwjJfFjQH-UtjEf71aSgA0aEEjqpE42MnLUYcQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Importing a Large .ndjson file  (Sankar P <sankar.curiosity@gmail.com>)
Ответы Re: Importing a Large .ndjson file  (Michael Lewis <mlewis@entrata.com>)
Re: Importing a Large .ndjson file  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Michel Pelletier
Дата:
Сообщение: Re: Hiding a GUC from SQL
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Importing a Large .ndjson file