Commit338c4e1

committed

Disable switch to bitmap scan seen in certain tests under large

artificial slowdown.

1 parent183f32b commit338c4e1Copy full SHA for 338c4e1

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -120,6 +120,8 @@ EXPLAIN (costs off)`
`120`	`120`	`SELECT id, id \|=>400FROM test_int4_h_oWHERE t @@'wr&qh'ORDER BY id \|=>400LIMIT5;`
`121`	`121`	`SELECT id, id \|=>400FROM test_int4_h_oWHERE t @@'wr&qh'ORDER BY id \|=>400LIMIT5;`
`122`	`122`
	`123`	`+SET enable_bitmapscan=OFF;`
	`124`	`+`
`123`	`125`	`EXPLAIN (costs off)`
`124`	`126`	`SELECT idFROM test_int4_h_oWHERE t @@'wr&qh'AND id<=400ORDER BY id;`
`125`	`127`	`SELECT idFROM test_int4_h_oWHERE t @@'wr&qh'AND id<=400ORDER BY id;`
`@@ -133,8 +135,6 @@ CREATE INDEX test_int4_h_a_idx ON test_int4_h_a USING rum`
`133`	`135`	`(t rum_tsvector_hash_addon_ops, id)`
`134`	`136`	`WITH (attach='id', to='t', order_by_attach='t');`
`135`	`137`
`136`		`-SET enable_bitmapscan=OFF;`
`137`		`-`
`138`	`138`	`EXPLAIN (costs off)`
`139`	`139`	`SELECTcount(*)FROM test_int4_h_aWHERE id<400;`
`140`	`140`	`SELECTcount(*)FROM test_int4_h_aWHERE id<400;`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -120,6 +120,8 @@ EXPLAIN (costs off)`
`120`	`120`	`SELECT id, id \|=>400FROM test_int8_h_oWHERE t @@'wr&qh'ORDER BY id \|=>400LIMIT5;`
`121`	`121`	`SELECT id, id \|=>400FROM test_int8_h_oWHERE t @@'wr&qh'ORDER BY id \|=>400LIMIT5;`
`122`	`122`
	`123`	`+SET enable_bitmapscan=OFF;`
	`124`	`+`
`123`	`125`	`EXPLAIN (costs off)`
`124`	`126`	`SELECT idFROM test_int8_h_oWHERE t @@'wr&qh'AND id<=400::int8ORDER BY id;`
`125`	`127`	`SELECT idFROM test_int8_h_oWHERE t @@'wr&qh'AND id<=400::int8ORDER BY id;`
`@@ -133,8 +135,6 @@ CREATE INDEX test_int8_h_a_idx ON test_int8_h_a USING rum`
`133`	`135`	`(t rum_tsvector_hash_addon_ops, id)`
`134`	`136`	`WITH (attach='id', to='t', order_by_attach='t');`
`135`	`137`
`136`		`-SET enable_bitmapscan=OFF;`
`137`		`-`
`138`	`138`	`EXPLAIN (costs off)`
`139`	`139`	`SELECTcount(*)FROM test_int8_h_aWHERE id<400::int8;`
`140`	`140`	`SELECTcount(*)FROM test_int8_h_aWHERE id<400::int8;`

Comments

(0)