3 ms·
The latter. What would slow down inserts is excessive indexing
by gaius 9y ago
The 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