Problemsby GlyphPostgreSQL queries run too slowly and are hard to tune
8 posts from 8 people8d activeFading, +0 this week
Posts per day
The posts behind it
Why does PostgreSQL ignore my B-tree index on WHERE upper(name) LIKE 'GARC%' and do a sequential scan?
I have a PostgreSQL 16 table with about 3 million rows. Searching customers by name prefix, case-insensitively, is slow. The query does a sequential scan even though name is indexed.. Environment: PostgreSQL 16.2, database encoding UTF8, collation en_US.UTF-8 .. Table and index:...
I almost upgraded my server because of one innocent dropdown
A client messaged me saying their order dashboard had become basically unusable. I opened it. Everything worked. They sent me a screen recording. Twelve seconds to load one report.. The app and postgreSQL database were running on a small serverspace VM, so my first thought was...
Melange: Compiling OpenFGA authorization into native PL/pgSQL functions (1 year later)
...authorization data synchronized with an application database adds overhead that I find hard to justify at smaller scales.. Melange takes a different approach: it compiles OpenFGA schemas into PL/pgSQL functions, with relationship traversals, unions, intersections, and exclusions...
I built a free SQL practice site where you answer requests from a fake CEO/Head of Growth instead of solving textbook puzzles. Looking for feedback
...built SQL Office Simulator.. You play the company's data analyst. Stakeholders send you messy business requests like "which regions have the highest share of repeat buyers in 2025, excluding cancelled orders?", and you explore the schema, write the query, and submit it.. How it...
Any good tools for identifying slow or inefficient queries?
...or otherwise inefficient queries. - maybe offer suggestions on improvements . Thanks for any suggestions .
How to design a polymorphic database schema for entities with structurally different shapes?
I'm building a backend that stores match data across multiple sports (football, basketball, tennis, cricket, MMA, etc.). The problem is these sports have fundamentally different structures:. Football: 2 halves, stoppage time, running score. . Basketball: 4 quarters, fouls that...
Major update to RDST - You can now ask your postgres database any question you want, unlimited and free under MIT License
...against BIRD, which is the standard benchmark for text-to-SQL. BIRD uses real databases, messy real-world schemas, and it scores by execution. The results for RDST against BIRD have been extremely encouraging; we have vastly improved our text2sql interface compared to raw model...
Feature request: Support pg_orca (Cascades-style query optimizer) as an alternative PostgreSQL optimizer
## Feature request **Is your feature request related to a problem?** PostgreSQL's built-in planner occasionally produces suboptimal plans for complex analytical queries (multi-way joins, subqueries, CTEs). A new open-source extension,...
Companies and products named
About this problem
Evidence
8 posts from 8 people in 4 places, about 1 a week over 62 days. Mostly on r/PostgreSQL, Stack Overflow [postgresql], supabase/supabase. Tools named alongside: GitHub, Supabase, MySQL, Vercel.
Frustration Frustration 1 of 3· Seen on Reddit, Stack Overflow, GitHub issues
How it was grouped
Posts that state a pain and match the "slow-queries" rule about PostgreSQL. First post Aug 29, 2026, latest Oct 29, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
The same problem elsewhere
Queries run too slowly and are hard to tune
5 posts from 5 people on GitHub issues, Stack Overflow.
ClickHouse queries run too slowly and are hard to tune
3 posts from 2 people on GitHub issues.
Other PostgreSQL problems
PostgreSQL users keep filing bugs
Top post: "Instance owner cannot view execution data in a team project when the execution uses a credential of that", one of 42 posts from 41 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL vulnerabilities are hard to triage and patch
2 posts from 2 people on Glyph Ibis. Unverified.
PostgreSQL upgrades break working setups
13 posts from 12 people on GitHub issues, Stack Overflow, Reddit.
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.
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 jobs fail silently or break often
5 posts from 4 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 4 posts from 4 people on GitHub issues, Stack Overflow.
PostgreSQL outages and slowdowns disrupt work
4 posts from 4 people on GitHub issues, Reddit.
Trouble with PostgreSQL credentials
Top post: "SFTP Credentials: Port field clears value and incorrectly formats large port numbers", one of 4 posts from 4 people on GitHub issues.
PostgreSQL connectors and syncs are fragile
4 posts from 4 people on GitHub issues, Hacker News.
History