Commit853d99a

Alena Rybakina

committed

Add limiting parameters to generate bitmapscan, hashjoin, mergejoin and material nodes.

1 parent6cf69af commit853d99aCopy full SHA for 853d99a

File tree

+10

-4

lines changed

+10

-4

lines changed

Lines changed: 6 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,6 +19,10 @@ ANALYZE aqo_test2;`
`19`	`19`	`CREATE EXTENSION aqo;`
`20`	`20`	`SET aqo.join_threshold = 0;`
`21`	`21`	`SET aqo.mode='intelligent';`
	`22`	`+SET enable_material = 'off';`
	`23`	`+SET enable_hashjoin = 'off';`
	`24`	`+SET enable_bitmapscan = 'off';`
	`25`	`+SET enable_mergejoin = 'off';`
`22`	`26`	`SELECT count(*) FROM aqo_test1 a, aqo_test2 b WHERE a.a=b.a;`
`23`	`27`	`count`
`24`	`28`	`-------`
`@@ -326,8 +330,7 @@ ORDER BY res;`
`326`	`330`	`t`
`327`	`331`	`t`
`328`	`332`	`t`
`329`		`- t`
`330`		`-(27 rows)`
	`333`	`+(26 rows)`
`331`	`334`
`332`	`335`	`-- Check if data is the same as in source, no result rows expected.`
`333`	`336`	`(TABLE aqo_data_dump EXCEPT TABLE aqo_data)`
`@@ -369,8 +372,7 @@ ORDER BY res;`
`369`	`372`	`t`
`370`	`373`	`t`
`371`	`374`	`t`
`372`		`- t`
`373`		`-(27 rows)`
	`375`	`+(26 rows)`
`374`	`376`
`375`	`377`	`-- Check if data is the same as in source, no result rows expected.`
`376`	`378`	`(TABLE aqo_data_dump EXCEPT TABLE aqo_data)`

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -22,6 +22,10 @@ CREATE EXTENSION aqo;`
`22`	`22`	`SETaqo.join_threshold=0;`
`23`	`23`
`24`	`24`	`SETaqo.mode='intelligent';`
	`25`	`+SET enable_material='off';`
	`26`	`+SET enable_hashjoin='off';`
	`27`	`+SET enable_bitmapscan='off';`
	`28`	`+SET enable_mergejoin='off';`
`25`	`29`
`26`	`30`	`SELECTcount(*)FROM aqo_test1 a, aqo_test2 bWHEREa.a=b.a;`
`27`	`31`	`SELECTcount(*)FROM aqo_test1 a, aqo_test2 b, aqo_test2 cWHEREa.a=b.aANDb.a=c.a;`

Comments

(0)