Commit333b4a4

committed

Cache most recent relfilenode lookups, for speed, after report of

pg_upgrade slowness for 150k tables.

1 parentad06db2 commit333b4a4Copy full SHA for 333b4a4

File tree

+11

-1

lines changed

+11

-1

lines changed

Lines changed: 11 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -423,11 +423,21 @@ relarr_lookup_rel(RelInfoArr *rel_arr,`
`423`	`423`	`constcharnspname,constcharrelname,`
`424`	`424`	`ClusterwhichCluster)`
`425`	`425`	`{`
`426`		`-intrelnum;`
	`426`	`+staticintrelnum=0;`
`427`	`427`
`428`	`428`	`if (!rel_arr\|\| !relname)`
`429`	`429`	`returnNULL;`
`430`	`430`
	`431`	`+/* Test most recent lookup first, for speed */`
	`432`	`+if (strcmp(rel_arr->rels[relnum].nspname,nspname)==0&&`
	`433`	`+strcmp(rel_arr->rels[relnum].relname,relname)==0)`
	`434`	`+return&rel_arr->rels[relnum];`
	`435`	`+`
	`436`	`+if (relnum+1<rel_arr->nrels&&`
	`437`	`+strcmp(rel_arr->rels[relnum+1].nspname,nspname)==0&&`
	`438`	`+strcmp(rel_arr->rels[relnum+1].relname,relname)==0)`
	`439`	`+return&rel_arr->rels[relnum+1];`
	`440`	`+`
`431`	`441`	`for (relnum=0;relnum<rel_arr->nrels;relnum++)`
`432`	`442`	`{`
`433`	`443`	`if (strcmp(rel_arr->rels[relnum].nspname,nspname)==0&&`

Comments

(0)