Thread: pg_locks in production

pg_locks in production

From
Wizard Brony
Date:
If performance is not an issue, is it valid to use the pg_locks system view in production code? Or are there other
concernsbesides performance that would make its use inappropriate for production? 



Re: pg_locks in production

From
Laurenz Albe
Date:
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