make installcheck.

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: make installcheck.
Date: 2014-11-21 15:14:21
Message-ID: 546F56CD.2070501@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

On production instance I have an installed preloaded library which affects
postgresql's optimizer (online_analyze if somebody is interesting). It works
well except executing make installcheck of other modules, for example btree_gist:

test numeric ... ok
test not_equal ... FAILED

=======================
1 of 25 tests failed.
=======================

It fails because of plan was changed, instead of

! Bitmap Heap Scan on test_ne
! Recheck Cond: ((a <> 'Thu Jan 01 00:00:00 2009'::timestamp without time
zone) AND (b <> 10.7))
! -> Bitmap Index Scan on test_ne_idx
! Index Cond: ((a <> 'Thu Jan 01 00:00:00 2009'::timestamp without time
zone) AND (b <> 10.7))

it get

! Index Scan using test_ne_idx on test_ne
! Index Cond: ((a <> 'Thu Jan 01 00:00:00 2009'::timestamp without time zone)
AND (b <> 10.7))

Is there any way to unload that library for test or, at least, execute set
statement (set online_analyze.enable = off, actually) on test database before
test run?

Thank you.

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-11-21 15:18:43 Re: make installcheck.
Previous Message Stephen Frost 2014-11-21 15:12:40 Re: superuser() shortcuts