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: | Raw Message | Whole Thread | 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 ... |