Transaction ID wraparound error

Up until a few weeks ago I thought I will never see transaction ID wraparound error on some of my databases. Not that I would miss it but it felt like something with very very low possibility of occurrence. Well, not any more… We implemented logical replication...

Transaction ID wraparound

This article summarizes information I have about this problem. I know that this is not all but I did not find such a summarization anywhere therefore I place it here. Maybe it could help to someone.   Transaction ID has 32 bits. It means that after ID 2147483648...

Autonomous transaction in PostgreSQL

I think this is really very well known. I add it here only as a reminder. In Oracle you can define “pragma autonomous_transaction” to force your procedure make changes in data regardless of any other pending transaction. This is really useful when you need...