Re: COPY threads
| От | Ravi Krishna |
|---|---|
| Тема | Re: COPY threads |
| Дата | |
| Msg-id | C61F9A0D-477C-4F9D-8C1E-2B6CBBEF7C99@aol.com обсуждение исходный текст |
| Ответ на | Re: COPY threads (Andres Freund <andres@anarazel.de>) |
| Ответы |
Re: COPY threads
|
| Список | pgsql-general |
> > 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 fireup 10 different COPY sessions , each reading from a split file, but copying into the same table. I thought not. It will be great if wecan do this.
В списке pgsql-general по дате отправления: