Re: Planner: rows=1 after "similar to" where condition.

>-----Original Message-----
>From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>Sent: Wednesday, 5 March 2008 0:29
>To: Joris Dobbelsteen
>Cc: Gregory Stark; Scott Marlowe; pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Planner: rows=1 after "similar to"
>where condition.
>
>"Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> writes:
[snip]
>> " Recheck Cond: (((program)::text = 'amavis'::text) AND
>> ((facility)::text = 'mail'::text))"
>
>selects rows that match the regex with much higher probability
>than the general row population does. Since we don't yet have
>any cross-column statistics the planner has no chance of
>realizing that.

Yes, that was it, should have realized that.

Thanks,

- Joris