How to use Postgres node with Multiple items(Array) without SplitInBatches

Questions
1

Describe the issue/error/question

SplitInBatches Causes high CPU usage, thus wanted to use the Postgres node executed for each item, but it breaks when the multiple-item array is fed to the Postgres Node

Information on your n8n setup

  • **n8n version: 0.204
  • **Database you’re using (default: SQLite): Postgres
  • **Running n8n with the execution process [own(default), main]: own
  • **Running n8n via [Docker, npm, n8n.cloud, desktop app]: Docker
1 Like
2

as suggested by @tom over discord,
You can typically work around this by using .first() when referencing another node as described on Built in methods and variables reference - n8n Documentation

eg:$(“node-name”).first().json.myValue

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.