Trouble with PostgreSQL filter
3 posts from 3 people3d activeFading, +0 this week
Posts per day
The posts behind it
Executions filter startedAfter/startedBefore shifted by the Postgres session time zone offset (zone-less UTC string vs timestamptz)
...the Postgres session time zone). External PostgreSQL 17 with server `timezone` UTC+2. Workaround applied: role-level `timezone = 'UTC'`. ### Operating System Debian 13 (Docker) ### n8n Version 2.47.7 ### Node.js Version bundled with the official Docker image 2.47.7 ### Database...
Flow run stored with a deeply nested, lone-surrogate or NaN-label value makes `/flow_runs/filter` return 500 for every client
### Bug summary The server stores some values that it can't serialize when reading them back. After that, every list request whose page includes the row returns 500 until the row is deleted. This is the same failure as #15031, but caused by different inputs, and the #15031 fix...
PostgreSQL /flow_runs/filter times out for state-filtered START_TIME_ASC queries on large flow_run tables
### Bug summary We observed `POST /flow_runs/filter` returning HTTP 500 for the following query against a self-hosted Prefect server using PostgreSQL: Our `flow_run` table contained approximately 6.35 million rows (26 GB), including approximately 27,000 `RUNNING` rows. Prefect...
Companies and products named
About this problem
Evidence
3 posts from 3 people in 2 places, about 1 a week over 61 days. Mostly on PrefectHQ/prefect, n8n-io/n8n. Tools named alongside: Prefect, SQLite, Infinity, Model Context Protocol.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts about PostgreSQL with no known issue, sharing the word "filter". First post Sep 15, 2026, latest Nov 14, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other PostgreSQL problems
PostgreSQL users keep asking for help
Top post: "How can I exclude sampling gaps when calculating accompanying time between two Ganos trajectories?", one of 44 posts from 43 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL upgrades break working setups
17 posts from 15 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL queries run too slowly and are hard to tune
10 posts from 10 people on Reddit, Stack Overflow, GitHub issues.
Trouble with PostgreSQL database
Top post: "Urgent: SIHSS Free Project Unhealthy, Database Recovery Required", one of 8 posts from 8 people on GitHub issues, Stack Overflow.
PostgreSQL error messages are cryptic
7 posts from 7 people on GitHub issues, Stack Overflow.
PostgreSQL permissions are confusing and error-prone
7 posts from 7 people on GitHub issues, Hacker News.
PostgreSQL jobs fail silently or break often
6 posts from 5 people on GitHub issues.
PostgreSQL feels slow and laggy
5 posts from 5 people on Mastodon, Reddit, GitHub issues.
Trouble with PostgreSQL workflow
Top post: "Agent not recognizing the workflow inputs", one of 5 posts from 5 people on GitHub issues, Stack Overflow.
PostgreSQL outages and slowdowns disrupt work
5 posts from 5 people on GitHub issues, Reddit.
PostgreSQL rate limits and usage caps block work
4 posts from 4 people on GitHub issues.
PostgreSQL vulnerabilities are hard to triage and patch
4 posts from 4 people on Glyph Ibis.
History