n8n/packages
Florian Gößler edcdcadc9d
perf(engine): Run the createSteps statements as static prepared statements
createSteps built its INSERT with one VALUES tuple per record, so the
statement text changed with the batch size. Now it passes one array for
each column through unnest, so the text is the same for every call.

Both createSteps statements (the execution-row lock and the insert) now
run as named prepared statements on the transaction's connection.
PostgreSQL parses and plans each one once per connection.

WITH ORDINALITY and ORDER BY keep the insert in input order, so
RETURNING still lists the created rows in the order of the records.

Named prepared statements need a direct connection or a session-mode
pooler. A transaction-mode PgBouncer before 1.21 does not support them.

Co-authored-by: Cursor <cursoragent@cursor.com>
2026-10-16 15:15:02 +02:00
..
@n8n perf(engine): Run the createSteps statements as static prepared statements 2026-10-16 15:15:02 +02:00
cli feat(engine): Add engine v2 tracing spans and a benchmark NoOp opt-in 2026-10-16 00:46:50 +02:00
core chore: Move the shared runtime-credential getter into BaseExecuteContext (#39470) 2026-10-06 09:37:56 +00:00
extensions/insights 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
frontend feat: Add the n8n Chat agent chat page, agents library and merged chat lists (no-changelog) (#40335) 2026-10-06 09:35:35 +00:00
modules 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
node-dev ci: Speed up the PR build job and move the E2E matrix off its path (no-changelog) (#39736) 2026-09-28 13:16:13 +00:00
nodes-base feat(Microsoft SharePoint Node): Add the event selector to the trigger (no-changelog) (#39987) 2026-10-06 09:11:25 +00:00
quality fix: Multiple migration timestamps withing a single PR (#40379) 2026-10-06 07:28:47 +00:00
workflow 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00