[Info-ingres] Triggers and locks

G Jones geraint.jones at ndph.ox.ac.uk
Tue Sep 12 14:41:54 UTC 2023


Perhaps partitioning the 'spider' table would help, so your concurrent rule-fired inserts are acting on multiple physical tables rather than just one.
(It's a less effective approach if spider has secondary indexes though, those can't be partitioned so a single index spans all partitions of the base table).


More information about the Info-ingres mailing list