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

Re: Planner create a slow plan without an available index

From: Ben-Nes Yonatan <da(at)canaan(dot)co(dot)il>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
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 07:36:04
Message-ID: 43155DE4.1030004@canaan.co.il (view raw or flat)
Thread:
Lists: pgsql-general
Martijn van Oosterhout wrote:
> 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,

No apprantly I just lack a decent sleep.... I think that ill stop ask 
you guys questions before you will decide to get your clubs out... :P
In other words I was mistaken and thought about a million and not a 
billion :)

With hopes that this is the end of my bugging :)
Thanks alot,
	Ben-Nes Yonatan

In response to

pgsql-general by date

Next:From: Matthew PeterDate: 2005-08-31 07:50:20
Subject: Re: optimum settings for dedicated box
Previous:From: Ben-Nes YonatanDate: 2005-08-31 07:19:05
Subject: Re: Planner create a slow plan without an available index

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