Hacker News new | ask | show | jobs
by 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.
1 comments

More importantly it doesn't help at all with cross-column correlations. It can help with skew in between various rows though.