On Thursday 04 May 2006 22:30, Jim C. Nasby wrote: >On Wed, May 03, 2006 at 04:28:10PM +0200, Leif B. Kristensen wrote: >> However, I'm wondering if there's a practical limit to how many rows >> you can insert within one transaction? > >I believe transactions are limited to 4B commands, so the answer would >be 4B rows. That is definitely not the case. I routinely do around 36000 inserts wrapped up in one transaction. I know that there is one hard-wired limit due to the OID wrap-around problem, at 2^31 commands in one transaction. But the practical limit due to hardware resources is probably much lower. -- Leif Biberg Kristensen :: Registered Linux User #338009 http://solumslekt.org/ :: Cruising with Gentoo/KDE
