Re: New feature: accumulative functions. - Mailing list pgsql-general

From pasman pasmański
Subject Re: New feature: accumulative functions.
Date
Msg-id CAOWY8=bMA2U1DVHojPus61-C2_yU7em7B4N2RLvSjGaHfr+Big@mail.gmail.com
Whole thread Raw
In response to Re: New feature: accumulative functions.  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
I write small summary.

Feature details: additional flags for monotonical functions. Learn
planner to use them. New node in execution plan - functional index
scan.

Pro: single btree index may be used in many expressions containing
only monotonnical functions.

Contra: big developement effort. No new functionalities - functional
or gist index does the same work. Not for all encodings. Unknown
performance advantages.


------------
pasman

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: (another ;-)) PostgreSQL-derived project ...
Next
From: Eduardo Morras
Date:
Subject: Re: looking for a faster way to do that