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