Re: [PERFORM] PostgreSQL does CAST implicitely between int andadomain derived from int

2009-08-27 Thread Jean-Michel Pouré
Le jeudi 27 août 2009 à 09:52 -0500, Kevin Grittner a écrit : > Just to get another data point, what happens if you run the same query > without taking the index out of the picture, but without the LIMIT or > OFFSET clauses? An EXPLAIN ANALYZE of that would help understand it > more fully. Also,

Re: [PERFORM] PostgreSQL does CAST implicitely between int andadomain derived from int

2009-08-27 Thread Kevin Grittner
Jean-Michel Pouré wrote: > ... Index Cond: ((tid)::integer = 3) > ... Index Cond: ((n.vid)::integer = (tn.vid)::integer) > ... Index Cond: ((ncs.nid)::integer = n.nid) > Total runtime: 0.092 ms Sorry, but I just had to point that out. I feel much better now. ;-) > Does it mean my index