Commit404ba54

committed

Test BRIN autosummarization

1 parentaa6b7b7 commit404ba54Copy full SHA for 404ba54

File tree

+44

-2

lines changed

+44

-2

lines changed

Lines changed: 5 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -16,15 +16,18 @@ include $(top_builddir)/src/Makefile.global`
`16`	`16`	`include$(top_srcdir)/contrib/contrib-global.mk`
`17`	`17`	`endif`
`18`	`18`
`19`		`-check: isolation-check`
	`19`	`+check: isolation-check prove-check`
`20`	`20`
`21`	`21`	`isolation-check: \| submake-isolation`
`22`	`22`	`$(MKDIR_P) isolation_output`
`23`	`23`	`$(pg_isolation_regress_check)\`
`24`	`24`	`--outputdir=./isolation_output\`
`25`	`25`	`$(ISOLATIONCHECKS)`
`26`	`26`
`27`		`-.PHONY: check isolation-check`
	`27`	`+prove-check:`
	`28`	`+$(prove_check)`
	`29`	`+`
	`30`	`+.PHONY: check isolation-check prove-check`
`28`	`31`
`29`	`32`	`submake-isolation:`
`30`	`33`	`$(MAKE) -C$(top_builddir)/src/test/isolation all`

Lines changed: 39 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,39 @@`
	`1`	`+# Verify that work items work correctly`
	`2`	`+`
	`3`	`+use strict;`
	`4`	`+use warnings;`
	`5`	`+`
	`6`	`+use TestLib;`
	`7`	`+use Test::Moretests=> 2;`
	`8`	`+use PostgresNode;`
	`9`	`+`
	`10`	`+my$node = get_new_node('tango');`
	`11`	`+$node->init;`
	`12`	`+$node->append_conf('postgresql.conf','autovacuum_naptime=1s');`
	`13`	`+$node->start;`
	`14`	`+`
	`15`	`+$node->safe_psql('postgres','create extension pageinspect');`
	`16`	`+`
	`17`	`+# Create a table with an autosummarizing BRIN index`
	`18`	`+$node->safe_psql('postgres',`
	`19`	`+'create table brin_wi (a int) with (fillfactor = 10);`
	`20`	`+ create index brin_wi_idx on brin_wi using brin (a) with (pages_per_range=1, autosummarize=on);`
	`21`	`+'`
	`22`	`+);`
	`23`	`+my$count =$node->safe_psql('postgres',`
	`24`	`+"select count(*) from brin_page_items(get_raw_page('brin_wi_idx', 2), 'brin_wi_idx'::regclass)"`
	`25`	`+);`
	`26`	`+is($count,'1',"initial index state is correct");`
	`27`	`+`
	`28`	`+$node->safe_psql('postgres',`
	`29`	`+'insert into brin_wi select * from generate_series(1, 100)');`
	`30`	`+`
	`31`	`+$node->poll_query_until('postgres',`
	`32`	`+"select count(*) > 1 from brin_page_items(get_raw_page('brin_wi_idx', 2), 'brin_wi_idx'::regclass)",`
	`33`	`+'t');`
	`34`	`+`
	`35`	`+$count =$node->safe_psql('postgres',`
	`36`	`+"select count(*) > 1 from brin_page_items(get_raw_page('brin_wi_idx', 2), 'brin_wi_idx'::regclass)"`
	`37`	`+);`
	`38`	`+is($count,'t',"index got summarized");`
	`39`	`+$node->stop;`

Comments

(0)