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/
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 |