Re: Prepared statements considered harmful - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Prepared statements considered harmful
Date
Msg-id 200608311529.15771.peter_e@gmx.net
Whole thread Raw
In response to Re: Prepared statements considered harmful  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
List pgsql-hackers
Am Donnerstag, 31. August 2006 15:06 schrieb Jeroen T. Vermeulen:
> Is there any kind of pattern at all to this problem?  Anything
> recognizable?  A few typical pitfalls?

If data is not distributed evenly, then any old WHERE foo = $1 is prone to be 
the wrong plan for half of the possible values of $1.  The more data you have 
and the more it changes, the worse this gets.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Prepared statements considered harmful
Next
From: Peter Eisentraut
Date:
Subject: Re: Prepared statements considered harmful