NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit3d9e8db

committed

Revert "Fix an O(N^2) problem in foreign key references".

Commit5ddc728 does not actually workbecause it will happily blow away ri_constraint_cache entries that arein active use in outer call levels. In any case, it's a very ugly,brute-force solution to the problem of limiting the cache size.Revert until it can be redesigned.

1 parent6820094 commit3d9e8dbCopy full SHA for 3d9e8db

File tree

1 file changed

-35

lines changed

src/backend/utils/adt
- ri_triggers.c

1 file changed

-35

lines changed

`‎src/backend/utils/adt/ri_triggers.c`

Lines changed: 3 additions & 35 deletions

Original file line number	Diff line number	Diff line change
`@@ -183,7 +183,6 @@ typedef struct RI_CompareHashEntry`
`183`	`183`	`* ----------`
`184`	`184`	`*/`
`185`	`185`	`staticHTAB*ri_constraint_cache=NULL;`
`186`		`-staticlongri_constraint_cache_seq_count=0;`
`187`	`186`	`staticHTAB*ri_query_cache=NULL;`
`188`	`187`	`staticHTAB*ri_compare_cache=NULL;`
`189`	`188`
`@@ -216,7 +215,6 @@ static bool ri_KeysEqual(Relation rel, HeapTuple oldtup, HeapTuple newtup,`
`216`	`215`	`staticboolri_AttributesEqual(Oideq_opr,Oidtypeid,`
`217`	`216`	`Datumoldvalue,Datumnewvalue);`
`218`	`217`
`219`		`-staticvoidri_InitConstraintCache(void);`
`220`	`218`	`staticvoidri_InitHashTables(void);`
`221`	`219`	`staticvoidInvalidateConstraintCacheCallBack(Datumarg,intcacheid,uint32hashvalue);`
`222`	`220`	`staticSPIPlanPtrri_FetchPreparedPlan(RI_QueryKey*key);`
`@@ -2947,20 +2945,6 @@ InvalidateConstraintCacheCallBack(Datum arg, int cacheid, uint32 hashvalue)`
`2947`	`2945`
`2948`	`2946`	`Assert(ri_constraint_cache!=NULL);`
`2949`	`2947`
`2950`		`-/*`
`2951`		`- * Prevent an O(N^2) problem when creating large amounts of foreign`
`2952`		`- * key constraints with ALTER TABLE, like it happens at the end of`
`2953`		`- * a pg_dump with hundred-thousands of tables having references.`
`2954`		`- */`
`2955`		`-ri_constraint_cache_seq_count+=hash_get_num_entries(ri_constraint_cache);`
`2956`		`-if (ri_constraint_cache_seq_count>1000000)`
`2957`		`-{`
`2958`		`-hash_destroy(ri_constraint_cache);`
`2959`		`-ri_InitConstraintCache();`
`2960`		`-ri_constraint_cache_seq_count=0;`
`2961`		`-return;`
`2962`		`-}`
`2963`		`-`
`2964`	`2948`	`hash_seq_init(&status,ri_constraint_cache);`
`2965`	`2949`	`while ((hentry= (RI_ConstraintInfo*)hash_seq_search(&status))!=NULL)`
`2966`	`2950`	`{`
`@@ -3380,15 +3364,13 @@ ri_NullCheck(HeapTuple tup,`
`3380`	`3364`
`3381`	`3365`
`3382`	`3366`	`/* ----------`
`3383`		`- * ri_InitConstraintCache`
`3384`		`- *`
`3385`		`- * Initialize ri_constraint_cache when new or being rebuilt.`
	`3367`	`+ * ri_InitHashTables -`
`3386`	`3368`	`*`
`3387`		`- * This needs to be done from two places, so split it out to prevent drift.`
	`3369`	`+ *Initialize our internal hash tables.`
`3388`	`3370`	`* ----------`
`3389`	`3371`	`*/`
`3390`	`3372`	`staticvoid`
`3391`		`-ri_InitConstraintCache(void)`
	`3373`	`+ri_InitHashTables(void)`
`3392`	`3374`	`{`
`3393`	`3375`	`HASHCTLctl;`
`3394`	`3376`
`@@ -3398,20 +3380,6 @@ ri_InitConstraintCache(void)`
`3398`	`3380`	`ri_constraint_cache=hash_create("RI constraint cache",`
`3399`	`3381`	`RI_INIT_CONSTRAINTHASHSIZE,`
`3400`	`3382`	`&ctl,HASH_ELEM \|HASH_BLOBS);`
`3401`		`-}`
`3402`		`-`
`3403`		`-/* ----------`
`3404`		`- * ri_InitHashTables -`
`3405`		`- *`
`3406`		`- *Initialize our internal hash tables.`
`3407`		`- * ----------`
`3408`		`- */`
`3409`		`-staticvoid`
`3410`		`-ri_InitHashTables(void)`
`3411`		`-{`
`3412`		`-HASHCTLctl;`
`3413`		`-`
`3414`		`-ri_InitConstraintCache();`
`3415`	`3383`
`3416`	`3384`	`/* Arrange to flush cache on pg_constraint changes */`
`3417`	`3385`	`CacheRegisterSyscacheCallback(CONSTROID,`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit3d9e8db

File tree

1 file changed

1 file changed

`‎src/backend/utils/adt/ri_triggers.c`

0 commit comments