>> 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