ACTIVITY
Timeline
Timeline for the post: PostgreSQL query becomes slow only with prepared statements
Currently licensed under: CC BY-SA 4.0
| When | What | By | License | Comment |
|---|---|---|---|---|
Sep 27, 2026, 10:54:55 PM 2w ago | Answer | matte_dev | CC BY-SA 4.0 | The logs and behaviour point in the same direction here. **Likely cause:** A generic prepared plan is poor for tenants whose row counts differ significantly. **What I would try:** Compare custom and generic plans with EXPLAIN ANALYZE, improve statistics and use an appropriate plan cache mode for the affected workload. Document the original value before changing it and restore it if the symptom remains. |
Sep 17, 2026, 11:50:04 AM 4w ago | Created | troublesync_editorial | CC BY-SA 4.0 | PostgreSQL query becomes slow only with prepared statements |