Query optimizer & prepared statements

From: Jack Orenstein <jack(dot)orenstein(at)hds(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Query optimizer & prepared statements
Date: 2009-06-23 20:33:39
Message-ID: 4A413C23.7090704@hds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If x is an integer column with an index, then

select ...
from T
where x > 1

and

select ...
from T
where x > 1000000000

could be optimized differently. So how is optimization done for a prepared
statement containing a variable, e.g.

select ...
from T
where x > $1

Jack Orenstein

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emanuel Calvo Franco 2009-06-23 20:39:46 Re: drawback of array vs join
Previous Message Radcon Entec 2009-06-23 20:27:38 Separating raise notice lines