Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: Re: [HACKER...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 2 Topic 4020 of 4424
Post > Topic >>

Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search

by tgl@[EMAIL PROTECTED] (Tom Lane) Apr 26, 2008 at 01:26 PM

Robert Treat <xzilla@[EMAIL PROTECTED]
> writes:
> On Friday 25 April 2008 17:32, Tom Lane wrote:
>> Robert Treat <xzilla@[EMAIL PROTECTED]
> writes:
>>> Oddly some dtrace profiling gave me this, which is pretty different,
but
>>> certainly doesn't have concerns about
TransactionIdIsCurrentTransactionId
>> 
>> .... which seems to pretty much destroy your thesis, no?

> How so? Before the patch we bog down for hours, spending 99% of our time
in  
> TransactionIdIsCurrentTransactionId, after the patch everything performs
well
> (really better than before) and we spend so little time in 
> TransactionIdIsCurrentTransactionId it barely shows up on the radar. 

Oh, you failed to state that the dtrace output was post-patch.  You need
to show *pre* patch dtrace output if you want us to think it relevant.

			regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
 




 2 Posts in Topic:
Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix
xzilla@[EMAIL PROTECTED]   2008-04-26 09:10:53 
Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrent
tgl@[EMAIL PROTECTED] (T  2008-04-26 13:26:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 7:24:34 CST 2008.