Re: Planner question - "bit" data types

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Karl Denninger <karl(at)denninger(dot)net>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Planner question - "bit" data types
Date: 2009-09-08 00:49:01
Message-ID: 603c8f070909071749l2467940l2ae5e3db3a0e3f0f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Sep 5, 2009 at 8:19 PM, Karl Denninger<karl(at)denninger(dot)net> wrote:
> There was a previous thread and I referenced it. I don't have the other one
> in my email system any more to follow up to it.
>
> I give up; the attack-dog crowd has successfully driven me off.  Ciao.

Perhaps I'm biased by knowing some of the people involved, but I don't
think anyone on this thread has been anything but polite. It would
certainly be great if PostgreSQL could properly estimate the
selectivity of expressions like this without resorting to nasty hacks,
but it can't, and unfortunately, there's really no possibility of that
changing any time soon. Even if someone implements a fix today, the
soonest it will appear in a production release is June 2010. So, any
suggestion for improvement is going to be in the form of suggesting
that you modify the schema in some way. I know that's not really what
you're looking for, but unfortunately it's the best we can do.

As far as I can tell, it is not correct to say that you referenced the
previous thread. I do not see any such reference.

...Robert

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Karl Denninger 2009-09-08 00:51:43 Re: Planner question - "bit" data types
Previous Message Fernando Hevia 2009-09-07 19:33:53 Re: Planner question - "bit" data types