4 ms·
Will that slow down inserts? Or am I understanding it wrong and this is just one time generation like vacuum analyze?
by comboy 9y ago
Will that slow down inserts? Or am I understanding it wrong and this is just one time generation like vacuum analyze?
- gaius 9y agoThe latter. What would slow down inserts is excessive indexing
- comboy 9y agoYeah, been there. Kinda too bad that it's just a one time thing. But even if it wouldn't be, I forgot that unlike index update it doesn't have to block transaction, it can be updated whenever later and doesn't have to be done after each insert. Anyway, postgres team is doing awesome things. So much great functionality while keeping it rock stable. Kudos.
- gaius 9y agoI assume once you’ve told it once it will maintain them when it autovacuums. But the correlations shouldn’t change that much if the source data is genuinely connected