Support Questions
Find answers, ask questions, and share your expertise

How to do database batch insert/update in Nifi

We are processing messages from Kafka within a short time span (about 20 million in 15 minutes) and inserting them into a Postgres DB. We're trying to improve throughput by batching the database inserts rather than running one for each message.

How would we batch database updates together and run them in configurable batch sizes?