> - Original Message -
>> From: Tom Lane
>> To: Denis de Bernardy
>> Cc: "pgsql-performance@postgresql.org"
>
>> Sent: Wednesday, May 4, 2011 4:12 PM
>> Subject: Re: [PERFORM] row estimate very wrong for array type
>>
>>
y, May 4, 2011 4:12 PM
> Subject: Re: [PERFORM] row estimate very wrong for array type
>
> Denis de Bernardy writes:
>> [ estimates for array && suck ]
>> Might this be a bug in the operator's selectivity, or am I doing
> something wrong?
>
> Array
Denis de Bernardy writes:
> [ estimates for array && suck ]
> Might this be a bug in the operator's selectivity, or am I doing something
> wrong?
Array && uses areasel() which is only a stub :-(
In the particular case here it'd be possible to get decent answers
just by trying the operator again
Hi,
I'm running into erroneous row estimates when using an array type, and I'm
running out of ideas on how to steer postgres into the right direction... I've
tried setting statistics to 1000, vacuuming and analyzing over and over,
rewriting the query differently... to no avail.
The table looks
