Re: COPY threads
От
Andres Freund
Тема
Re: COPY threads
Дата
Msg-id
10F9B024-556C-4C8E-B8F5-9461A4696BCA@anarazel.de
Ответ на
Re: COPY threads (Ravi Krishna)
Список
Дерево обсуждения
COPY threads Rob Sargent <robjsargent@gmail.com>
Re: COPY threads Laurenz Albe <laurenz.albe@cybertec.at>
Re: COPY threads Andres Freund <andres@anarazel.de>
Re: COPY threads Ravi Krishna <srkrishna1@aol.com>
Re: COPY threads Christopher Browne <cbbrowne@gmail.com>
Re: COPY threads Ravi Krishna <srkrishna1@aol.com>
Re: COPY threads Andres Freund <andres@anarazel.de>
Re: COPY threads Ravi Krishna <srkrishna1@aol.com>
Re: COPY threads Andres Freund <andres@anarazel.de>
Re: COPY threads Ravi Krishna <srkrishna1@aol.com>
Re: COPY threads "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: COPY threads Ravi Krishna <srkrishna1@aol.com>
Re: COPY threads Ravi Krishna <srkrishna1@aol.com>
Re: COPY threads Rob Sargent <robjsargent@gmail.com>
Re: COPY threads Rob Sargent <robjsargent@gmail.com>
Re: COPY threads Thomas Kellerer <spam_eater@gmx.net>
On October 10, 2018 2:15:19 PM PDT, Ravi Krishna wrote: >> >> pg_restore doesn't take locks on the table for the COPY, it does so >> because creating the table takes an exclusive lock. > > >Interesting. I seem to recollect reading here that I can't have >concurrent COPY on the same table because of the lock. >To give an example: > >If I have a large file with say 400 million rows, can I first split it >into 10 files of 40 million rows each and then fire up 10 different >COPY sessions , each reading from a split file, but copying into the >same table. I thought not. It will be great if we can do this. Yes, you can. Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
В списке pgsql-general по дате отправления
