3 ms·
> Cross-column Statistics Holy crap I didn't even know this was feasible much less in development! Can't wait to test this out, as significant amount of my dat
by pbnjay 9y ago
> Cross-column Statistics
Holy crap I didn't even know this was feasible much less in development! Can't wait to test this out, as significant amount of my data sets have these kinds of relationships.
Parallel query will also be great for certain queries I do regularly. Been looking forward to this!
Thank you Thank you to all the devs that had a part of this!
- bonesmoses 9y agoCross-column statistics are one of my favorites. The way Postgres 10 handles it is really a _huge_ advancement that addresses a painful edge case that has been around for ages. https://blog.2ndquadrant.com/pg-phriday-crazy-correlated-column-crusade/ https://blog.2ndquadrant.com/pg-phriday-crazy-correlated-col...
- ComodoHacker 9y agoTo be honest, skewed data problem can be addressed with partitioning in many cases. Cross-column statistics is a great feature nevertheless.
- pgaddict 9y agoYes, but partitioning also has a number of limitations that may be quite undesirable. Like inability to create UNIQUE constraints or primary keys, for example.
- anarazel 9y agoMore importantly it doesn't help at all with cross-column correlations. It can help with skew in between various rows though.
- pgaddict 9y agoThanks, I'm happy it got into PG10 too. Just to make it very clear - the current implementation is fairly simple, and may not be smart enough to deal with more complicated dependencies between columns. Hopefully that will be improved in PG11.