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@sigaev.ru
WWW: http://www.sigaev.ru/
