Hi, I am using the ExecuteSQL processor in NiFi to write records to PostgreSQL. The problem I have is when running on multi-thread (for example 10), the processor gets stuck and runs too slow. This doesn't happen in a single thread. However, single thread is not efficient so doesn't work for me. After getting slow, I stop the processor, terminate it, and start it again. For almost 5-10 seconds everything is ok and then the same problem. I also have a similar problem with the InvokeHTTP processor. Thank you in advance.
... View more