On Tue, 2024-02-20 at 05:46 +0000, Lars Aksel Opsahl wrote:
> If this is expected behavior it means that any user on the database that writes
> a long running sql that does not even insert any data can kill performance for
> any other user in the database.
Yes, that is the case. A long running query will hold a snapshot, and no data
visible in that snapshot can be deleted.
That can cause bloat, which can impact performance.
> So applications like QGIS who seems to keep open connections for a while can
> then also kill the performance for any other user in the data.
No, that is not a problem. Keeping *connections* open is a good thing. It is
keeping data modifying transactions, cursors or long-running queries open
that constitutes a problem.
Yours,
Laurenz Albe