Tag: transactions

Get the Newest PostgreSQL Info, Tips & Tricks

Here you can find all blog posts about the Tag: transactions. You can go back to all blog posts or take a look into our other categories & tags.

Row locks in PostgreSQL

by Laurenz Albe | 04.2023

The PostgreSQL documentation has some information about row locks. But typically, you cannot see them in pg_locks, and not […]

How To & Performance

Stored procedures in PostgreSQL: getting started

by Hans-Jürgen Schönig | 02.2023

Learn all about stored procedures in PostgreSQL right here with examples created by a database expert. Includes syntax & tips

How To

LISTEN / NOTIFY: Automatic client notification in PostgreSQL

by Hans-Jürgen Schönig | 09.2022

If 1000's of users constantly poll the database, a lot of load is caused for no benefit. LISTEN / NOTIFY is a better way, find out how.

How To

PostgreSQL: Sequences vs. Invoice numbers

by Hans-Jürgen Schönig | 09.2022

What's the problem with using PostgreSQL database side sequences to create unique invoice numbers to send to clients? Let's find out.

How To

Transaction anomalies with SELECT FOR UPDATE

by Laurenz Albe | 06.2022

I was recently confronted with a nice example of how adding FOR UPDATE to a query can introduce transaction […]

How To

WITH HOLD cursors and transactions in PostgreSQL

by Laurenz Albe | 10.2021

Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions […]

How To

PostgreSQL grouping sets: ROLLUP & CUBE

by Hans-Jürgen Schönig | 08.2021

PostgreSQL offers many OLAP-style workload features. One of those features is called “GROUPING SETS”. Let's deep dive into ROLLUP & CUBE:

How To

Speeding up count(*): Why not use max(id) - min(id)

by Hans-Jürgen Schönig | 04.2020

The usage of max(id) - min(id) to speed up count(*) may seem like a good approach when it comes to speeding up the process, but it can be problematic.

How To

Subtransactions and performance in PostgreSQL

by Laurenz Albe | 03.2020

(Last updated on 2023-01-24) Recently, while troubleshooting PostgreSQL performance problems, I ran into problems with subtransactions twice. So I […]

Performance