>-----Original Message----- >From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] >Sent: Wednesday, 5 March 2008 0:29 >To: Joris Dobbelsteen >Cc: Gregory Stark; Scott Marlowe; pgsql-general@xxxxxxxxxxxxxx >Subject: Re: Planner: rows=1 after "similar to" >where condition. > >"Joris Dobbelsteen" <Joris@xxxxxxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
