Re: [GENERAL] Really poor gist index performance with tstzrange types

On Tue, Jun 11, 2013 at 5:13 PM, Tom Lane wrote: > Joe Van Dyk writes: >> Am I doing something silly? Or is the row-estimation for gist indexes not >> even close in this case? > > 9.2 didn't have any logic for estimating range << conditions. I see > reasonable estimates for this case in HEAD, th

Re: [GENERAL] Really poor gist index performance with tstzrange types

Joe Van Dyk writes: > Am I doing something silly? Or is the row-estimation for gist indexes not > even close in this case? 9.2 didn't have any logic for estimating range << conditions. I see reasonable estimates for this case in HEAD, though, presumably thanks to work by Alexander Korotkov.

[GENERAL] Really poor gist index performance with tstzrange types

Am I doing something silly? Or is the row-estimation for gist indexes not even close in this case? https://gist.github.com/joevandyk/503cc3d836ee5d101224/raw/c6fc53b2da06849d3d04effbd1c147fc36124245/gistfile1.txtor code below: -- This is not running inside a transaction. drop table if exists f;