jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction, or does that just reflect the already documented row, table and database limits?
Well, the system will need to be able to roll back the transaction, so at some point your system will grind to a halt. I shouldn't be surprised if there was some counter that couldn't cope beyond 2^31 rows too but no-one's found it yet.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq