Query optimizer & prepared statements - Mailing list pgsql-general

From Jack Orenstein
Subject Query optimizer & prepared statements
Date
Msg-id 4A413C23.7090704@hds.com
Whole thread Raw
Responses Re: Query optimizer & prepared statements
Re: Query optimizer & prepared statements
List 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


pgsql-general by date:

Previous
From: Radcon Entec
Date:
Subject: Separating raise notice lines
Next
From: Emanuel Calvo Franco
Date:
Subject: Re: drawback of array vs join