Created 01-05-2021 12:35 AM
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.