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@svana.org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy