Hooks or another better way to track session objects

2025-06-24 Thread Roman Khapov
dback on the general idea, advices on a clean wayto implement such notifications, and comments on the attached POC patches.If you have ideas, experience with similar tasks, or suggestions for abetter (or more canonical) Postgres way to approach this, please let me know. Thanks! Best r

[PATCH v2] Re: Cancel problems of query to pg_stat_statements

2025-05-12 Thread Roman Khapov
Description: Binary data > On 28 Apr 2025, at 11:16, Andrey Borodin wrote: > > > >> On 24 Apr 2025, at 22:49, Roman Khapov wrote: >> >> Hi! >> Recently we faced a problem in out production psql installation, which was >> that we had to cancel all

Cancel problems of query to pg_stat_statements

2025-04-24 Thread Roman Khapov
Hi! Recently we faced a problem in out production psql installation, which was that we had to cancel all requests to the db, including performance monitoring requests, that uses ps_stat_statements. But we could not cancel the request in usual way, and had to kill -9 the pg process of it. We've noti