| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | drheart(at)wanadoo(dot)es |
| Cc: | Lista PostgreSql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problem (bug?) with like |
| Date: | 2001-12-03 18:31:23 |
| Message-ID: | 20011203193123.B480@lorien.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
bombadil(at)wanadoo(dot)es writes:
> Here are my queries:
You sure you didn't paste in the same result for #2 and #3? They're
the same plan with the same rows estimates --- but I'd expect the rows
estimates, at least, to change given the more-selective LIKE pattern.
Also, how many rows are there really that match '%DA%' and '%DAVID%'?
I suspect the planner is being overoptimistic about the selectivity of
'%DAVID%', and is choosing a plan that doesn't work well when there are
lots of DAVIDs :-(
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Barnard | 2001-12-03 18:35:26 | Re: libpq Newbie question |
| Previous Message | bombadil | 2001-12-03 18:30:33 | Re: Problem (bug?) with like |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-12-03 18:32:15 | Re: case sensititvity bug in foreign keys on cygwin |
| Previous Message | bombadil | 2001-12-03 18:30:33 | Re: Problem (bug?) with like |