Re: [HACKERS] Surjective functional indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Surjective functional indexes
Date
Msg-id 15995.1495730260@sss.pgh.pa.us
Whole thread Raw
In response to [HACKERS] Surjective functional indexes  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: [HACKERS] Surjective functional indexes  (Andres Freund <andres@anarazel.de>)
Re: [HACKERS] Surjective functional indexes  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
List pgsql-hackers
Konstantin Knizhnik <k.knizhnik@postgrespro.ru> writes:
> My proposal is to check value of function for functional indexes instead 
> of just comparing set of effected attributes.
> Obviously, for some complex functions it may  have negative effect on 
> update speed.
> This is why I have added "surjective" option to index.

This seems overcomplicated.  We would have to compute the function
value at some point anyway.  Can't we refactor to do that earlier?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Konstantin Knizhnik
Date:
Subject: [HACKERS] Surjective functional indexes
Next
From: Jeff Janes
Date:
Subject: Re: [HACKERS] CREATE STATISTICS statistic_type documentation