Tag: lock

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: lock. 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 have side effects which have the potential to cause serious issues in production. […]

Debugging deadlocks in PostgreSQL

by Laurenz Albe | 06.2022
  (Updated 2023-04-07) Even if you understand what a deadlock is, debugging deadlocks can be tricky. This article shows some […]

Constraints over multiple rows in PostgreSQL

by Hans-Jürgen Schönig | 06.2021
Manage constraints over multiple rows: In PostgreSQL and many other relational databases, constraints are an integral part of the feature […]

Disabling autocommit in PostgreSQL can damage your health

by Laurenz Albe | 06.2021
  When analyzing customer's problems, I have seen the mess you can get into if you disable autocommit in your […]

PostgreSQL: Understanding deadlocks

by Hans-Jürgen Schönig | 04.2021
Many might have seen PostgreSQL issue the following error message: "ERROR: deadlock detected". But what does it really mean? How […]

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

Be prepared for prepared transactions

by Laurenz Albe | 12.2018
Prepared transactions are disabled in PostgreSQL by default, since the parameter max_prepared_transactions has the default value 0. You don't need […]

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

SKIP LOCKED: One of my favorite 9.5 features

by Hans-Jürgen Schönig | 07.2015
PostgreSQL 9.5 is just around the corner and many cool new features have been added to this wonderful release. One […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

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

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