Postgres Pro
Downloads
Home   >   mailing lists

Re: Lack of index usage when doing array casts - Mailing list pgsql-performance

From Tom Lane
Subject Re: Lack of index usage when doing array casts
Date
Msg-id 19686.1393020721@sss.pgh.pa.us
Whole thread Raw
In response to Re: Lack of index usage when doing array casts  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Lack of index usage when doing array casts
List pgsql-performance
Tree view 
I wrote:
> Hmm.  IIRC the text to enum cast is considered stable not immutable, which
> is why that doesn't get folded to a Const on sight.  However, it seems
> like it'd be okay for scalararraysel() to reduce stable expressions for
> estimation purposes, ie it should be using estimate_expression_value.

I've committed a patch for this; it will be in 9.3.4.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lack of index usage when doing array casts
Next
From: Alexey Klyukin
Date:
Subject: Re: Lack of index usage when doing array casts