Hacker News new | past | comments | ask | show | jobs | submit login

Practically speaking: A long-running transaction is one that issues BEGIN, locks some rows, then blocks on other network input, and finally COMMIT. Once a day/week/month that input arrives very slowly and the COMMIT happens minutes or hours after the BEGIN.



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

Search: