Postgres Pro
Downloads
Home   >   mailing lists

Re: Really poor gist index performance with tstzrange types - Mailing list pgsql-general

From Tom Lane
Subject Re: Really poor gist index performance with tstzrange types
Date
Msg-id 22700.1370996034@sss.pgh.pa.us
Whole thread Raw
In response to Really poor gist index performance with tstzrange types  (Joe Van Dyk <joe@tanga.com>)
Responses Re: Really poor gist index performance with tstzrange types  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
Tree view 
Joe Van Dyk <joe@tanga.com> 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.

            regards, tom lane

pgsql-general by date:

Previous
From: Joe Van Dyk
Date:
Subject: Really poor gist index performance with tstzrange types
Next
From: Sergey Konoplev
Date:
Subject: Re: Really poor gist index performance with tstzrange types