pg_locks in production

Started by Wizard Bronyover 1 year ago2 messagesgeneral
Jump to latest
#1Wizard Brony
wizardbrony@gmail.com

If performance is not an issue, is it valid to use the pg_locks system view in production code? Or are there other concerns besides performance that would make its use inappropriate for production?

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Wizard Brony (#1)
Re: pg_locks in production

On Thu, 2024-09-19 at 15:08 -0400, Wizard Brony wrote:

If performance is not an issue, is it valid to use the pg_locks
system view in production code? Or are there other concerns
besides performance that would make its use inappropriate for production?

There are no concerns if you use pg_locks on a production system.

Yours,
Laurenz Albe