Transaction sizes and PostgreSQL protections

Transactions and Error Handling in PostgreSQL

Jason Myers

Principal Engineer

Keep transactions small

Easier to reason about
Database Performance
Error domains

Dividing operations

BEGIN TRANSACTION;

INSERT sales SET quantity=6 
WHERE name='chocolate chip';

INSERT baking_list SET quantity=12 
WHERE name='chocolate chip';

UPDATE inventory SET quantity = quantity - 6 
WHERE name='oatmeal dark chocolate';

COMMIT;

Is this a transaction?

UPDATE cookies SET deliciousness = 11 WHERE name = 'Ginger Molasses';

What about selects?

SELECT deliciousness FROM cookies where name = 'ANZAC';

Let's practice!

Transactions and Error Handling in PostgreSQL