--- /home/andres/src/postgresql/src/test/regress/expected/create_index.out 2013-12-08 19:57:01.646559353 +0100 +++ /home/andres/build/postgres/dev-assert/vpath/src/test/regress/results/create_index.out 2013-12-11 16:54:00.043641015 +0100 @@ -2720,11 +2720,15 @@ SELECT unique1 FROM tenk1 WHERE unique1 IN (1,42,7) ORDER BY unique1; - QUERY PLAN -------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: (unique1 = ANY ('{1,42,7}'::integer[])) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Sort + Sort Key: unique1 + -> Bitmap Heap Scan on tenk1 + Recheck Cond: (unique1 = ANY ('{1,42,7}'::integer[])) + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = ANY ('{1,42,7}'::integer[])) +(6 rows) SELECT unique1 FROM tenk1 WHERE unique1 IN (1,42,7) ====================================================================== --- /home/andres/src/postgresql/src/test/regress/expected/subselect.out 2013-12-11 16:42:18.791039738 +0100 +++ /home/andres/build/postgres/dev-assert/vpath/src/test/regress/results/subselect.out 2013-12-11 16:54:06.823376218 +0100 @@ -727,7 +727,7 @@ -> Seq Scan on public.tenk1 b Output: b.unique1, b.unique2, b.two, b.four, b.ten, b.twenty, b.hundred, b.thousand, b.twothousand, b.fivethous, b.tenthous, b.odd, b.even, b.stringu1, b.stringu2, b.string4 SubPlan 1 - -> Index Only Scan using tenk1_unique1 on public.tenk1 a + -> Seq Scan on public.tenk1 a Output: a.unique1 (10 rows) ====================================================================== --- /home/andres/src/postgresql/src/test/regress/expected/join.out 2013-12-08 19:57:01.649892559 +0100 +++ /home/andres/build/postgres/dev-assert/vpath/src/test/regress/results/join.out 2013-12-11 16:54:08.439979745 +0100 @@ -3354,16 +3354,16 @@ explain (costs off) select count(*) from tenk1 a, tenk1 b join lateral (values(a.unique1)) ss(x) on b.unique2 = ss.x; - QUERY PLAN ------------------------------------------------------------------- + QUERY PLAN +----------------------------------------------------- Aggregate -> Hash Join Hash Cond: ("*VALUES*".column1 = b.unique2) -> Nested Loop - -> Index Only Scan using tenk1_unique1 on tenk1 a + -> Seq Scan on tenk1 a -> Values Scan on "*VALUES*" -> Hash - -> Index Only Scan using tenk1_unique2 on tenk1 b + -> Seq Scan on tenk1 b (8 rows) select count(*) from tenk1 a, ====================================================================== --- /home/andres/src/postgresql/src/test/regress/expected/rowtypes.out 2013-12-08 19:14:10.614689754 +0100 +++ /home/andres/build/postgres/dev-assert/vpath/src/test/regress/results/rowtypes.out 2013-12-11 16:54:31.072429133 +0100 @@ -240,11 +240,15 @@ select thousand, tenthous from tenk1 where (thousand, tenthous) >= (997, 5000) order by thousand, tenthous; - QUERY PLAN ------------------------------------------------------------ - Index Only Scan using tenk1_thous_tenthous on tenk1 - Index Cond: (ROW(thousand, tenthous) >= ROW(997, 5000)) -(2 rows) + QUERY PLAN +----------------------------------------------------------------------- + Sort + Sort Key: thousand, tenthous + -> Bitmap Heap Scan on tenk1 + Recheck Cond: (ROW(thousand, tenthous) >= ROW(997, 5000)) + -> Bitmap Index Scan on tenk1_thous_tenthous + Index Cond: (ROW(thousand, tenthous) >= ROW(997, 5000)) +(6 rows) select thousand, tenthous from tenk1 where (thousand, tenthous) >= (997, 5000) ======================================================================