Skip site navigation (1) Skip section navigation (2)

Re: Prepared statements considered harmful

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Prepared statements considered harmful
Date: 2006-08-31 13:29:15
Message-ID: 200608311529.15771.peter_e@gmx.net (view raw or flat)
Thread:
Lists: 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/

In response to

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2006-08-31 13:30:25
Subject: Re: Prepared statements considered harmful
Previous:From: Peter EisentrautDate: 2006-08-31 13:25:32
Subject: Re: Prepared statements considered harmful

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group