Commit4a8bc39

committed

Speed up hash_index regression test.

Commitf5ab0a1 made this test take substantially longer than it usedto. With a bit more care, we can get the runtime back down whileachieving the same, or even a bit better, code coverage.Mithun CyDiscussion:https://postgr.es/m/CAD__Ouh-qaEb+rD7Uy-4g3xQYOrhPzHs-a_TrFAjiQ5azAW5+w@mail.gmail.com

1 parent16ebab6 commit4a8bc39Copy full SHA for 4a8bc39

File tree

-11

lines changed

-11

lines changed

Lines changed: 4 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -200,9 +200,9 @@ SELECT h.seqno AS f20000`
`200`	`200`	`-- Cause some overflow insert and splits.`
`201`	`201`	`--`
`202`	`202`	`CREATE TABLE hash_split_heap (keycol INT);`
	`203`	`+INSERT INTO hash_split_heap SELECT 1 FROM generate_series(1, 500) a;`
`203`	`204`	`CREATE INDEX hash_split_index on hash_split_heap USING HASH (keycol);`
`204`		`-INSERT INTO hash_split_heap SELECT 1 FROM generate_series(1, 70000) a;`
`205`		`-VACUUM FULL hash_split_heap;`
	`205`	`+INSERT INTO hash_split_heap SELECT 1 FROM generate_series(1, 5000) a;`
`206`	`206`	`-- Let's do a backward scan.`
`207`	`207`	`BEGIN;`
`208`	`208`	`SET enable_seqscan = OFF;`
`@@ -213,11 +213,10 @@ MOVE BACKWARD 10000 FROM c;`
`213`	`213`	`MOVE BACKWARD ALL FROM c;`
`214`	`214`	`CLOSE c;`
`215`	`215`	`END;`
`216`		`--- DELETE, INSERT,REBUILD INDEX.`
	`216`	`+-- DELETE, INSERT,VACUUM.`
`217`	`217`	`DELETE FROM hash_split_heap WHERE keycol = 1;`
`218`		`-INSERT INTO hash_split_heap SELECT a/2 FROM generate_series(1,50000) a;`
	`218`	`+INSERT INTO hash_split_heap SELECT a/2 FROM generate_series(1,25000) a;`
`219`	`219`	`VACUUM hash_split_heap;`
`220`		`-REINDEX INDEX hash_split_index;`
`221`	`220`	`-- Clean up.`
`222`	`221`	`DROP TABLE hash_split_heap;`
`223`	`222`	`-- Index on temp table.`

Lines changed: 4 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -156,10 +156,9 @@ SELECT h.seqno AS f20000`
`156`	`156`	`-- Cause some overflow insert and splits.`
`157`	`157`	`--`
`158`	`158`	`CREATETABLEhash_split_heap (keycolINT);`
	`159`	`+INSERT INTO hash_split_heapSELECT1FROM generate_series(1,500) a;`
`159`	`160`	`CREATEINDEXhash_split_indexon hash_split_heap USING HASH (keycol);`
`160`		`-INSERT INTO hash_split_heapSELECT1FROM generate_series(1,70000) a;`
`161`		`-`
`162`		`-VACUUM FULL hash_split_heap;`
	`161`	`+INSERT INTO hash_split_heapSELECT1FROM generate_series(1,5000) a;`
`163`	`162`
`164`	`163`	`-- Let's do a backward scan.`
`165`	`164`	`BEGIN;`
`@@ -173,12 +172,11 @@ MOVE BACKWARD ALL FROM c;`
`173`	`172`	`CLOSE c;`
`174`	`173`	`END;`
`175`	`174`
`176`		`--- DELETE, INSERT,REBUILD INDEX.`
	`175`	`+-- DELETE, INSERT,VACUUM.`
`177`	`176`	`DELETEFROM hash_split_heapWHERE keycol=1;`
`178`		`-INSERT INTO hash_split_heapSELECT a/2FROM generate_series(1,50000) a;`
	`177`	`+INSERT INTO hash_split_heapSELECT a/2FROM generate_series(1,25000) a;`
`179`	`178`
`180`	`179`	`VACUUM hash_split_heap;`
`181`		`-REINDEX INDEX hash_split_index;`
`182`	`180`
`183`	`181`	`-- Clean up.`
`184`	`182`	`DROPTABLE hash_split_heap;`

Comments

(0)