| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bill Chandler <billybobc1210(at)yahoo(dot)com> |
| Cc: | Kris Jurka <books(at)ejurka(dot)com>, pgsql-jdbc(at)postgresql(dot)org, pgsql-perform(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Cursors performance |
| Date: | 2004-07-13 17:08:57 |
| Message-ID: | 16994.1089738537@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-performance |
Bill Chandler <billybobc1210(at)yahoo(dot)com> writes:
> One final clue before I go: if I change my wildcard to
> 'NEPOOL%' from 'NEPOOL%REAL%' my query completes much
> faster.
Could we see the exact queries and EXPLAIN ANALYZE output for both
cases? I'm wondering if the plan changes. I think that the planner
will believe that the latter pattern is significantly more selective
(how much more selective depends on exactly which PG version you're
using); if this results in a bad row-count estimate then a bad plan
could get picked.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Smith | 2004-07-13 17:33:36 | Re: Windows port installer |
| Previous Message | Kris Jurka | 2004-07-13 16:55:56 | Re: Windows port installer |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-07-13 17:10:30 | Re: Insert are going slower ... |
| Previous Message | Hervé Piedvache | 2004-07-13 16:50:52 | Insert are going slower ... |