3 ms·
Yeah, 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 transact
by comboy 9y ago
Yeah, 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