Data and AI struggles

1,483 problems · 320 companies

Databases

Trouble with PostgreSQL server

3 posts from 3 people3d activeSteady, +1 this week

Posts per day

Posts per day3 posts, Sep 1 to Nov 2

The posts behind it

Stack OverflowStack Overflow [postgresql] · Harry_GoyalOct 29

SQL Server to PostgreSQL sync missing some records

I'm trying to keep a PostgreSQL table in sync with SQL Server. I'm using last_modified to get the new and updated rows, but noticed that some records are missing. Seems to happen when a few rows have the same timestamp.. I tried using >= instead of > and that gets everything,...

GitHub issuesfosrl/pangolin · MauryaQbitOct 5

deleteOrgById loads only one site (.limit(1) at server/lib/deleteOrg.ts:59), skipping per-site cleanup for the rest

## Describe the Bug `deleteOrgById` loads an org's sites with `.limit(1)`, so the loop that performs per-site cleanup only runs once. Database rows end up fine because the org delete cascades, but the side effects that only exist outside the database get skipped for every other...

Redditr/dataengineering · u/Comprehensive_Level7Sep 1

extracting data from on-prem databases (sql server, oracle, postgres) to cloud, which options you guys recommend?

...one of the things we're thinking is to retire the ADF. the reason is simple: ADF is a pain in the ass (we're having a hard time working with it specially because it was another company that build all that shit, the connection with Azure DevOps/Repos is always horrible to manage...

Companies and products named

3 posts
2 posts
1 post
1 post
About this problem

Evidence

3 posts from 3 people in 3 places, about 1 a week over 59 days. Mostly on r/dataengineering, fosrl/pangolin, Stack Overflow [postgresql]. Tools named alongside: SQL Server, Oracle, Databricks, Apache Airflow.

Frustration Frustration 0 of 3· Seen on Reddit, GitHub issues, Stack Overflow

How it was grouped

Posts about PostgreSQL with no known issue, sharing the word "server". First post Sep 1, 2026, latest Oct 29, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

Other PostgreSQL problems

PostgreSQL users keep filing bugs

Top post: "Postgres row-level security leaks across tenants when using a pooled connection", one of 41 posts from 39 people on GitHub issues, Stack Overflow, Reddit.

PostgreSQL upgrades break working setups

12 posts from 11 people on GitHub issues, Stack Overflow, Reddit.

PostgreSQL queries run too slowly and are hard to tune

8 posts from 8 people on Reddit, Stack Overflow, GitHub issues.

Trouble with PostgreSQL database

Top post: "Canonicalising unit names from a flat file in a normalised database structure", one of 6 posts from 6 people on GitHub issues, Stack Overflow.

PostgreSQL error messages are cryptic

6 posts from 6 people on GitHub issues, Stack Overflow.

PostgreSQL permissions are confusing and error-prone

5 posts from 5 people on GitHub issues, Hacker News.

PostgreSQL feels slow and laggy

4 posts from 4 people on Mastodon, Reddit, GitHub issues.

PostgreSQL connectors and syncs are fragile

4 posts from 4 people on GitHub issues, Hacker News.

Trouble with PostgreSQL flow

Top post: "schedule trigger not triggering the flow", one of 3 posts from 3 people on GitHub issues.

PostgreSQL hits connection, locking and scaling limits

3 posts from 3 people on Reddit, GitHub issues, Stack Overflow.

Trouble with PostgreSQL shared

Top post: "The same UPDATE intermittently needs far more shared buffers for about a minute", one of 3 posts from 3 people on GitHub issues, Stack Overflow.

Trouble with PostgreSQL jsonb

Top post: "Should semi-structured product attributes (secondary images, specs) be stored as JSONB or normalized tables?", one of 3 posts from 3 people on Stack Overflow.

History

First seen with 3 posts; the top post now: "SQL Server to PostgreSQL sync missing some records".

Nov 2, 2026