Question : This is pretty simple, but I’m baffled by what PG does (v9.0). We start with a simple table: […]
Tag: serialization
Send data from SQL to a serial port or IP address
Question : I’ve been asked to integrate SQL transaction data with a video monitoring system in real-time. The video system’s […]
debugging PostgreSQL serialization failures
Question : I am trying to migrate our PostgreSQL 9.4 database from transaction level READ COMMITTED to either REPEATABLE READ […]
How to configure read transactions to never cause other write serialization transactions to fail
Question : I am protecting critical transactions with application mutexes and SERIALIZABLE. I presume that this makes these operations as […]
Data type for protobuf objects in mysql
Question : I would like to store some protobuf objects in a MySQL database. The objects are created in a […]
PostgreSQL Serialisation failure on different ids
Question : Serializable isolation mode can be used to avoid race conditions when upserting equal ids. So for create table […]
How do I implement insert-if-not-found for transactions at serializable isolation level?
Question : I’m having a hard time figuring out how to exactly implement a ‘insert if not found’ function. Consider […]
Does READ COMMITTED always start over after serialization failures while SERIALIZABLE simply fails?
Question : On the PostgreSQL Concurrency With MVCC page, it says: know what you’re thinking though: what about a two […]
Postgres: turn off formating for xml export?
Question : I want to export some table to xml file: o output.xml SELECT table_to_xml(‘modified_records’, TRUE, TRUE, ”); However, I’m […]
Does READ COMMITTED always start over after serialization failures while SERIALIZABLE simply fails?
Question : On the PostgreSQL Concurrency With MVCC page, it says: know what you’re thinking though: what about a two […]
- 1
- 2