Jean-Pierre, First off, you're on Windows?
> " -> Seq Scan on price p (cost=0.00..11317.75 rows=581475 width=4) > (actual time=0.004..1143.720 rows=581475 loops=1)" Well, this is your pain point. Can we see the index scan plan on 8.1? Given that it's *expecting* only one row, I can't understand why it's using a seq scan ... > "Nested Loop Left Join (cost=0.00..11.02 rows=1 width=0) (actual > time=0.000..0.000 rows=1 loops=1)" > " -> Nested Loop Left Join (cost=0.00..5.48 rows=1 width=4) (actual > time=0.000..0.000 rows=1 loops=1)" > "Total runtime: 0.000 ms" Feh, this looks like the "windows does not report times" bug, which makes it hard to compare ... -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq