4 ms·
The biggest issue related to statistics I've encountered is when using jsonb columns. As far as I understand they have a hardcoded statistic, which can cause pr
by fabian2k 9y ago
The biggest issue related to statistics I've encountered is when using jsonb columns. As far as I understand they have a hardcoded statistic, which can cause pretty bad plans if your data isn't close to that value. You can create an index on individual keys in the jsonb column, which do have their own statistic, but that is not really an option for most cases where you'd use jsonb in the first place.
Bad statistics can really mess up queries, so any tool to fix this kind of situation is very welcome. I don't think this specific tool would help with this variant of bad statistics, unfortunately.
- joevandyk 9y agohttps://blog.anayrat.info/en/2017/11/26/postgresql---jsonb-and-statistics/ https://blog.anayrat.info/en/2017/11/26/postgresql---jsonb-a... explains this problem in more detail.