4 ms·
This is intriguing; could you give an example of a distribution Postgres struggles with at scale, and an application that produces such a distribution?
by claytonjy 6y ago
This is intriguing; could you give an example of a distribution Postgres struggles with at scale, and an application that produces such a distribution?
- mkilling 6y agoWe’ve recently been surprised by wrong estimates made by the planner resulting in inefficient query plans. It seems that power law distributions over multiple tables aren’t handled very well: https://stackoverflow.com/questions/65861780/is-there-a-way-to-improve-postgresql-estimates-when-joining-skewed-relations/65862472#65862472 https://stackoverflow.com/questions/65861780/is-there-a-way-...