Jean-Michel Pouré<jm@xxxxxxxxx> 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 is broken and should be rebuilt? No, probably not. 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. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
