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

PostgreSQL 32-bit transaction identifiers are cycled in a ring. This is why PostgreSQL needs to "freeze" old transaction identifiers before they could start being identified as future. This routine is "vacuum freeze" and it have to scan and re-write pages, which could have no dead rows.


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

Search: