Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Will that slow down inserts? Or am I understanding it wrong and this is just one time generation like vacuum analyze?


The latter. What would slow down inserts is excessive indexing


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.


I 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




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: