On Fri, Oct 21, 2005 at 12:25:36PM +0200, Nicolas Barbier wrote: > On 10/21/05, Richard Huxton <dev@archonet.com> wrote: > > jeff sacksteder wrote: > > > Are there known limits to how many rows can be inserted by one > > > transaction, > > > Well, the system will need to be able to roll back the transaction, ... > > Just by not indicating that a transaction did commit, others will keep > ignoring its rows. There is nothing to rollback here, thanks to MVCC.
Also, I've just done 300 million row INSERTs, from a 'mysqldump', inside a single transaction. So there doesn't appear to be any implementation problems that would stop you from reaching the theoretical table limits. -Mark ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq