Skip site navigation (1) Skip section navigation (2)

Re: Planner create a slow plan without an available index

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Ben-Nes Yonatan <da(at)canaan(dot)co(dot)il>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>,Bruno Wolff III <bruno(at)wolff(dot)to>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,pgsql-general(at)postgresql(dot)org
Subject: Re: Planner create a slow plan without an available index
Date: 2005-08-31 06:25:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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
one transaction.

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>
> 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 ZacksDate: 2005-08-31 06:50:23
Subject: Re: or kills performance
Previous:From: gokulnathbabu manoharanDate: 2005-08-31 05:31:09
Subject: Re: Invalid page header in pg_class

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group