Postgres Pro
Downloads
Home   >   mailing lists

COPY from STDIN vs file with large CSVs - Mailing list pgsql-admin

From Wells Oliver
Subject COPY from STDIN vs file with large CSVs
Date
Msg-id CAOC+FBVjk4W=nhn3FZUiTgroFFhaQ6bvh-NiU207PhD9nO3Qww@mail.gmail.com
Whole thread Raw
Responses Re: COPY from STDIN vs file with large CSVs  (Ron <ronljohnsonjr@gmail.com>)
RE: COPY from STDIN vs file with large CSVs  (Indirani Venkopa Chetty <ivchetty@crosslinktax.com>)
Re: COPY from STDIN vs file with large CSVs  (bricklen <bricklen@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Shrikant Bhende
Date:
Subject: Re: Alter command getting stuck on a table
Next
From: Indirani Venkopa Chetty
Date:
Subject: RE: COPY from STDIN vs file with large CSVs