Re: Really poor gist index performance with tstzrange types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Van Dyk <joe(at)tanga(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Really poor gist index performance with tstzrange types
Date: 2013-06-12 00:13:54
Message-ID: 22700.1370996034@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Van Dyk <joe(at)tanga(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2013-06-12 02:13:59 Re: Really poor gist index performance with tstzrange types
Previous Message Joe Van Dyk 2013-06-11 23:17:35 Really poor gist index performance with tstzrange types