On Thu, Nov 29, 2007 at 02:44:25PM -0800, Gautam Sampathkumar wrote: > Hi, > > I'm using a python script w/ the PyGreSQL library to insert 1 billion rows > into a database table for an experiment (performing a commit every 10K > rows). My script failed at about 170M rows with the following exception: You don't indicate your version so it could be XID wraparound, but you'd have to be running a pretty old version to run into that still... > After this error, my database table no longer exists and appeared to have > been dropped, although my script was doing only INSERT statements. Any ideas > on what might be causing this and/or if this a known issue and possible > solutions would be greatly appreciated. Do you run VACUUM regularly? Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution inevitable. > -- John F Kennedy
Attachment:
signature.asc
Description: Digital signature
