>-----Original Message-----
>From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>Sent: Wednesday, 5 March 2008 0:29
>To: Joris Dobbelsteen
>Cc: Gregory Stark; Scott Marlowe; pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Planner: rows=1 after "similar to"
>where condition.
>
>"Joris Dobbelsteen" <Joris@familiedobbelsteen.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
