Re: COPY FROM STDIN instead of INSERT

Поиск
Список
Период
Сортировка
От Ilja Golshtein
Тема Re: COPY FROM STDIN instead of INSERT
Дата
Msg-id 45367661.000001.26259@camay.yandex.ru
обсуждение исходный текст
Ответ на Re: COPY FROM STDIN instead of INSERT  (Casey Duncan <casey@pandora.com>)
Список pgsql-general
>> Is it Ok to use COPY BINARY FROM STDIN instead of multiple INSERTs?

>I don't think I would use BINARY, it seems likely to be susceptible
>to changes in the underlying data type storage. From the docs:
>"To determine the appropriate binary format for the actual tuple data
>you should consult the PostgreSQL source

[skipped]

Yes, it's a problem, though it's solved already. I use BINARY for, say, initial data loading.


>AFIAK, the locking semantics are the same as INSERT, i.e., it
>does not lock the entire table or anything like that. Since it would
>allow transactions that insert data to finish faster, it should
>actually work better under high concurrency.

Do hope that's right.

Thanks.

--
Best regards
Ilja Golshtein

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Stats Collector Won't Start
Следующее
От: "Karen Hill"
Дата:
Сообщение: Re: division by zero error in a request