Re: parameterized query much much slower than one with hard-coded string

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Timbo Chen <timbo(at)powerreviews(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: parameterized query much much slower than one with hard-coded string
Date: 2011-11-10 05:57:41
Message-ID: CA+0W9LOU1jb=ngTEDY7g5g49RsgR6fd+yGAkahxzBpqBH7n01Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 10 November 2011 17:44, Timbo Chen <timbo(at)powerreviews(dot)com> wrote:
> what could be the possible reason that these 2 nearly identical queries have
> such different performance?

> different execution plans?

Yes.

> how would i find out what the actual execution
> plan was?

EXPLAIN ANALYZE?

Oliver

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Timbo Chen 2011-11-10 08:30:05 Re: parameterized query much much slower than one with hard-coded string
Previous Message Timbo Chen 2011-11-10 04:44:12 parameterized query much much slower than one with hard-coded string