Re: Make HeapTupleSatisfiesMVCC more concurrent - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Make HeapTupleSatisfiesMVCC more concurrent
Date
Msg-id 20150819150038.GA15922@awork2.anarazel.de
Whole thread Raw
In response to Re: Make HeapTupleSatisfiesMVCC more concurrent  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2015-08-19 10:55:00 -0400, Tom Lane wrote:
> My own thought about reducing the cost of XidInMVCCSnapshot, if that
> proves necessary, is that maybe it would be worth the trouble to sort
> the arrays so we could use binary search.  That would increase the
> cost of snapshot acquisition noticeably though.

It's also considerably more expensive for search in many cases because
it's very hard to predict (branching and prefetching). I doubt it'd be
worthwhile.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Make HeapTupleSatisfiesMVCC more concurrent
Next
From: Simon Riggs
Date:
Subject: Re: DBT-3 with SF=20 got failed