Tom Lane wrote:
[ enlarging on Richard's response a bit ]
John Meinel <[EMAIL PROTECTED]> writes:
jfmeinel=> explain analyze execute myget(3);
QUERY PLAN
Seq Scan on tdata (co
[ enlarging on Richard's response a bit ]
John Meinel <[EMAIL PROTECTED]> writes:
> jfmeinel=> explain analyze execute myget(3);
> QUERY PLAN
>
> Seq Scan on tdata (cost=0.
Richard Huxton wrote:
John Meinel wrote:
So notice that when doing the actual select it is able to do the index
query. But for some reason with a prepared statement, it is not able
to do it.
Any ideas?
In the index-using example, PG knows the value you are comparing to. So,
it can make a bette
John Meinel wrote:
So notice that when doing the actual select it is able to do the index
query. But for some reason with a prepared statement, it is not able to
do it.
Any ideas?
In the index-using example, PG knows the value you are comparing to. So,
it can make a better estimate of how many
Tom Lane wrote:
John Meinel <[EMAIL PROTECTED]> writes:
... However, if I try to
bundle this query up into a server side function, it runs very slow (10
seconds). I'm trying to figure out why, but since I can't run EXPLAIN
ANALYZE inside a function, I don't really know what else to do.
A parame
