"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > HOT works because EDB refused to accept the inherit limitations of > PostgreSQL. COPY is no different in that aspect. Maybe it can't go > exponentially faster but the math says, "if done correctly, it can".
You can always make it faster if it doesn't have to give the right answer ;-). Or in more practical terms in this case, we have to balance speed against potentially-large costs in maintainability, datatype extensibility, and suchlike issues if we are going to try to get more than percentage points out of straight COPY. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq