Re: [PERFORM] Strange nested loop for an INSERT

2016-09-12 Thread phb07
Thanks, Tom, for this quick answer. Le 12/09/2016 à 16:41, Tom Lane a écrit : phb07 writes: The performance issue, encountered in very specific situations, is the time needed to cancel a significant number of insertions. I have build a simple test case that reproduces the problem without the

Re: [PERFORM] Strange nested loop for an INSERT

2016-09-12 Thread Tom Lane
phb07 writes: > The performance issue, encountered in very specific situations, is the > time needed to cancel a significant number of insertions. > I have build a simple test case that reproduces the problem without the > need of the extension. It just mimics the behaviour. At least for this e

[PERFORM] Strange nested loop for an INSERT

2016-09-12 Thread phb07
Hi all, One of my customer has reported to me a performance problem when using the E-Maj extension. It is a tool that allows to log updates performed on application tables, with the capability to cancel them. It is based on classic triggers with a log table associated to each application table.