pgsql: Prevent index-only scans in stats regression test.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Prevent index-only scans in stats regression test.
Date: 2011-10-09 04:21:39
Message-ID: E1RCktP-0008Fw-Oo@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Prevent index-only scans in stats regression test.

This bollixes the test because it's expecting to see the idx_tup_fetch
counter increase, which won't happen if heap fetches were avoided by use
of an index-only scan. Per buildfarm results.

While at it, let's just make sure that enable_seqscan and enable_indexscan
are ON for this test ...

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/45401c1c25fe1ef14bf68089de86bcb5cce9f453

Modified Files
--------------
src/test/regress/expected/stats.out | 5 +++++
src/test/regress/sql/stats.sql | 6 ++++++
2 files changed, 11 insertions(+), 0 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2011-10-09 16:00:34 pgsql: Clean up a couple of box gist helper functions.
Previous Message Tom Lane 2011-10-08 15:09:27 pgsql: Note that index-only scans can affect idx_tup_fetch.