Re: Gist cost estimates

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthias <nitrogenycs(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Gist cost estimates
Date: 2012-01-31 21:14:40
Message-ID: 10623.1328044480@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthias <nitrogenycs(at)googlemail(dot)com> writes:
> I've noticed the new range data types in 9.2dev. I'm really looking
> forward to use them, so I built postgres 9.2dev on windows to try.
> ...
> Do you have any explanation for these grossly wrong cost estimates?

The range operators don't have any selectivity estimation worthy of the
name yet. I'm still hoping to see that fixed before 9.2 final, but
the days grow short ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-01-31 21:19:44 Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation
Previous Message Andrew Dunstan 2012-01-31 20:23:02 Re: [GENERAL] pg_dump -s dumps data?!