database - How can I increase the number of triggers executed simultaneously in PostgreSQL? -


i have table foreign key constraints many clients load data simultaneously. noticed when there few clients adding new data works fine, however, more 10 clients slows down significantly! have idea why happening? postgresql says that: "each new row requires entry in server's list of pending trigger events (since firing of trigger checks row's foreign key constraint). loading many millions of rows can cause trigger event queue overflow available memory, leading intolerable swapping or outright failure of command." cannot remove triggers in case. know how increase size of list of pending trigger events? did not observer swapping disk. moreover, check locks using query:

select locktype, relname, pid, mode pg_locks,pg_class pg_locks.relation=pg_class.oid; 

and locks don't show special.


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -