Hacker News new | ask | show | jobs
by ComodoHacker 3189 days ago
To be honest, skewed data problem can be addressed with partitioning in many cases.

Cross-column statistics is a great feature nevertheless.
1 comments
pgaddict 3189 days ago
Yes, but partitioning also has a number of limitations that may be quite undesirable. Like inability to create UNIQUE constraints or primary keys, for example.
link
anarazel 3189 days ago
More importantly it doesn't help at all with cross-column correlations. It can help with skew in between various rows though.
link