Postgres Pro
Downloads
Home   >   mailing lists

Re: parameterized query much much slower than one with hard-coded string - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: parameterized query much much slower than one with hard-coded string
Date
Msg-id CA+0W9LOU1jb=ngTEDY7g5g49RsgR6fd+yGAkahxzBpqBH7n01Q@mail.gmail.com
Whole thread Raw
In response to parameterized query much much slower than one with hard-coded string  (Timbo Chen <timbo@powerreviews.com>)
Responses Re: parameterized query much much slower than one with hard-coded string
List pgsql-jdbc
Tree view 
On 10 November 2011 17:44, Timbo Chen <timbo@powerreviews.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

pgsql-jdbc by date:

Previous
From: Timbo Chen
Date:
Subject: parameterized query much much slower than one with hard-coded string
Next
From: Oliver Jowett
Date:
Subject: Re: parameterized query much much slower than one with hard-coded string