On Wed, Aug 31, 2005 at 09:19:05AM +0200, Ben-Nes Yonatan wrote:
> >If the subtransaction writes at least a tuple, it counts as another
> >transaction. Else it doesn't count.
> Oh crap I fear that now im in serious troubles....
> Where can I read about this limitation? and beside that what if I count
> the number of queries and every 900,000 or so I create a subtransaction
> and continue my process with it, will that work or I'm just trying to be
> a smart ass with the db?
Um, 1 billion transactions is 1 thousand million. So 900,000
inserts/updates are not even one tenth of one percent of the limit for
Are you really approaching a billion inserts/updates per transaction?
That's alot of diskspace being used...
Have a nice day,
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
In response to
pgsql-general by date
|Next:||From: Sim Zacks||Date: 2005-08-31 06:50:23|
|Subject: Re: or kills performance|
|Previous:||From: gokulnathbabu manoharan||Date: 2005-08-31 05:31:09|
|Subject: Re: Invalid page header in pg_class |