CYBERTEC PostgreSQL Logo

Tag: concurrency

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: concurrency. 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 […]

ALTER TABLE ... ADD COLUMN … done right in PostgreSQL

by Hans-Jürgen Schönig | 08.2022
Running ALTER TABLE … ADD COLUMN can cause serious issues in production. Understand how to cleanly change PostgreSQL data structures.

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 […]

Fixing out-of-sync sequences in PostgreSQL

by Hans-Jürgen Schönig | 08.2021
This post shows how to deal with out of sync PostgreSQL sequences in underlying tables using open-source pg_sequence_fixer extension

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 […]

"LOCK TABLE" can harm your database's health

by Laurenz Albe | 03.2019
  Many people know that explicit table locks with LOCK TABLE are bad style and usually a consequence of bad […]

What's in an xmax?

by Laurenz Albe | 04.2018
xmax is a PostgreSQL system column that is used to implement Multiversion Concurrency Control (MVCC). The documentation is somewhat terse: […]
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram