[PERFORM] slow join not using index properly

tual time=0.007..0.015 rows=6 loops=2084) Index Cond: (ancestor_key = collection_data.context_key) Heap Fetches: 13007 Buffers: shared hit=14929 Total runtime: 76.431 ms Why can't I get the Postgres 9.2.5 instance to use the optimal plan? Thanks in advance! /Stefan -- - Stefan Amshey

Re: [PERFORM] slow join not using index properly

> FROM > virtual_ancestors a1 where context_key > cont_key order by > context_key limit 1) from qq where cont_key is not null > ) > select a1.cont_key > from qq a1, collection_data, virtual_ancestors a2 > WHERE > a1.anc_key = collection_data.context_key >