COPY from STDIN vs file with large CSVs

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема COPY from STDIN vs file with large CSVs
Дата
Msg-id CAOC+FBVjk4W=nhn3FZUiTgroFFhaQ6bvh-NiU207PhD9nO3Qww@mail.gmail.com
обсуждение исходный текст
Ответы Re: COPY from STDIN vs file with large CSVs
RE: COPY from STDIN vs file with large CSVs
Re: COPY from STDIN vs file with large CSVs
Список pgsql-admin
I have a CSV that's ~30GB. Some 400m rows. Would there be a meaningful performance difference to run COPY from STDIN using: cat f.csv | psql "COPY .. FROM STDIN WITH CSV" versus just doing "COPY ... FROM 'f.csv' WITH CSV"?

Thanks. It took about four hours to copy one and I felt that was a little much.

--

В списке pgsql-admin по дате отправления: