Re: [HACKERS] Performance improvement for unique checks

2010-03-27 Thread Gokulakannan Somasundaram
> > Please write it, then test the performance and publish your results, > with a detailed analysis of whether there is benefit and in which cases > there is a loss. > > > Thanks. Will do it. Just wanted to know, whether the idea will get rejected right away / worth trying out. Thanks, Gokul.

Re: [HACKERS] Performance improvement for unique checks

2010-03-27 Thread Simon Riggs
On Sat, 2010-03-27 at 02:23 +0530, Gokulakannan Somasundaram wrote: >Since we insert a new entry into the index for every update that's > being made into the table, we inevitably make a unique check against > the older version of the newly inserted row, even when the values are > not updated.

[HACKERS] Performance improvement for unique checks

2010-03-26 Thread Gokulakannan Somasundaram
Hi, Since we insert a new entry into the index for every update that's being made into the table, we inevitably make a unique check against the older version of the newly inserted row, even when the values are not updated. Of course i am talking about non-HOT updates. (We will not go to the inde