n8n/packages/@n8n
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
..
agents 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
ai-node-sdk 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
ai-utilities 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
ai-workflow-builder.ee 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
api-types 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
backend-common 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
backend-network 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
backend-services 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
backend-test-utils 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
blob-storage 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
chat-hub 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
cli 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
client-oauth2 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
codemirror-lang 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
codemirror-lang-html 🚀 Release 2.41.0 (#39228) 2026-09-22 07:18:44 +00:00
codemirror-lang-sql 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
computer-use 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
config feat(engine): Add engine v2 tracing spans and a benchmark NoOp opt-in 2026-10-16 00:46:50 +02:00
constants 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
crdt 🚀 Release 2.42.0 (#39826) 2026-09-29 07:11:00 +00:00
create-node 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
db feat(core): Persist trusted source metadata and discover it asynchronously (no-changelog) (#40048) 2026-10-06 09:14:52 +00:00
decorators feat(core): Stop a durable system task run when its claim is lost (no-changelog) (#40272) 2026-10-06 09:07:37 +00:00
di 🚀 Release 2.40.0 (#38711) 2026-09-15 13:02:15 +03:00
engine perf(engine): Run the createSteps statements as static prepared statements 2026-10-16 15:15:02 +02:00
errors 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
eslint-config refactor: Group quality engineering workspaces by capability (#40007) 2026-10-01 11:20:00 +00:00
eslint-plugin-community-nodes 🚀 Release 2.42.0 (#39826) 2026-09-29 07:11:00 +00:00
expression-runtime 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
extension-sdk 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
imap 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
inbound-auth feat(core): Persist trusted source metadata and discover it asynchronously (no-changelog) (#40048) 2026-10-06 09:14:52 +00:00
instance-ai 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
json-schema-to-zod 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
local-gateway chore: Bundle/2.x (#39935) 2026-09-30 07:44:10 +03:00
mcp-apps 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
mcp-browser 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
mcp-browser-extension chore: Migrate remaining simple base packages to Oxlint (#40255) 2026-10-05 10:04:49 +03:00
module-cli chore: Remove legacy CODEOWNERS file (#40266) 2026-10-05 08:14:37 +00:00
node-cli 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
node-engine-compatibility perf(engine): Cut database round trips on the step settle and run paths 2026-10-16 15:01:28 +02:00
nodes-langchain 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
oxlint-config chore: Add typescript/no-deprecated and establish a baseline (#40168) 2026-10-02 12:54:37 +00:00
permissions 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
scan-community-package 🚀 Release 2.42.0 (#39826) 2026-09-29 07:11:00 +00:00
scheduler feat(core): Stop a durable system task run when its claim is lost (no-changelog) (#40272) 2026-10-06 09:07:37 +00:00
stylelint-config build: Remove unused dependencies reported by knip (no-changelog) (#38591) 2026-09-14 13:22:42 +00:00
syslog-client 🚀 Release 2.42.0 (#39826) 2026-09-29 07:11:00 +00:00
task-runner 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
task-runner-python chore: Bundle/2.x (#38765) 2026-09-16 07:52:44 +03:00
telemetry 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
tournament 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
typeorm 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
typescript-config 🚀 Release 2.40.0 (#38711) 2026-09-15 13:02:15 +03:00
utils 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
vitest-config 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00
workflow-sdk 🚀 Release 2.43.0 (#40376) 2026-10-06 07:10:16 +00:00