From: | Greg Stark <gsstark(at)mit(dot)edu> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | Greg Stark <gsstark(at)mit(dot)edu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Speeding up LIKE with placeholders? |
Date: | 2004-09-12 03:36:09 |
Message-ID: | 87u0u4xiom.fsf@stark.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Kinda ironic that a seemingly very nice feature (seperating query from
> arguments) has such a side-effect (less information for planner).
It was an known and expected downside.
But there is an upside too. For me it's actually a benefit, because it means
I'm less likely to called in the middle of the night because the web site when
someone entered some unusual parameters and caused a bad plan.
Whatever plan it's using when I test it will be the same as the plan it uses
for others, which may not be ideal but it won't be a surprise and I can
anticipate whether it'll be a reasonable plan in the future.
I can't anticipate all the potential plans the database might come up with for
all the possible parameters.
--
greg
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2004-09-12 04:43:18 | Re: Synchronizing Databases |
Previous Message | Kevin Barnard | 2004-09-12 01:37:53 | Re: What is the postgres version of mysql's "ON DUPLICATE KEY" |