Quoth [EMAIL PROTECTED] (ow): > Hypothetical situation: a table containing, say, 10 billion rows is backed up > and then restored with pg_restore. Would this lead to the transaction id > wraparound issue since 10B rows are imported in one "batch"?
No. Copying the 10 billion rows in only consumes one xid. - If you're in "autocommit mode," then each SQL statement consumes one xid. - If you type in BEGIN;, then you could have 10 billion SQL statements after that, and they would, altogether, consume 1 xid. -- "aa454","@","freenet.carleton.ca" http://www3.sympatico.ca/cbbrowne/sgml.html To iterate is human; to recurse, divine. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
