Re: [PERFORM] GIST optimization to limit calls to operator on sub nodes

2014-07-01 Thread Pujol Mathieu
Le 30/06/2014 16:04, Tom Lane a écrit : Pujol Mathieu writes: Le 29/06/2014 22:30, Tom Lane a écrit : I don't actually understand what's being requested here that the NotConsistent case doesn't already cover. The NotConsistent case is correctly covered, the sub nodes are not tested because I

Re: [PERFORM] GIST optimization to limit calls to operator on sub nodes

2014-06-30 Thread Tom Lane
Pujol Mathieu writes: > Le 29/06/2014 22:30, Tom Lane a écrit : >> I don't actually understand what's being requested here that the >> NotConsistent case doesn't already cover. > The NotConsistent case is correctly covered, the sub nodes are not > tested because I know that no child could pass t

Re: [PERFORM] GIST optimization to limit calls to operator on sub nodes

2014-06-30 Thread Pujol Mathieu
Le 29/06/2014 22:30, Tom Lane a écrit : Emre Hasegeli writes: Pujol Mathieu : I made my own index to handle specific data and operators. It works pretty fine but I wonder if it was possible to optimize it. When I run my operator on a GIST node (in the method gist_range_consistent) it returns

Re: [PERFORM] GIST optimization to limit calls to operator on sub nodes

2014-06-30 Thread Pujol Mathieu
Le 29/06/2014 22:14, Emre Hasegeli a écrit : Pujol Mathieu : Hello, I already post my question in the General Mailing list, but without succeed so I try this one that seems to me more specialized. My question is about GIST index. I made my own index to handle specific data and operators. It wor

Re: [PERFORM] GIST optimization to limit calls to operator on sub nodes

2014-06-29 Thread Tom Lane
Emre Hasegeli writes: > Pujol Mathieu : >> I made my own index to handle specific data and operators. It works >> pretty fine but I wonder if it was possible to optimize it. >> When I run my operator on a GIST node (in the method >> gist_range_consistent) it returns "NotConsistent" / >> "MaybeCons

Re: [PERFORM] GIST optimization to limit calls to operator on sub nodes

2014-06-29 Thread Emre Hasegeli
Pujol Mathieu : > Hello, > I already post my question in the General Mailing list, but without > succeed so I try this one that seems to me more specialized. > My question is about GIST index. > I made my own index to handle specific data and operators. It works > pretty fine but I wonder if it was

[PERFORM] GIST optimization to limit calls to operator on sub nodes

2014-06-23 Thread Pujol Mathieu
Hello, I already post my question in the General Mailing list, but without succeed so I try this one that seems to me more specialized. My question is about GIST index. I made my own index to handle specific data and operators. It works pretty fine but I wonder if it was possible to optimize it