Re: Transaction Size in PostgreSQL
От
Mladen Gogala
Тема
Re: Transaction Size in PostgreSQL
Дата
Msg-id
181170a8-cf42-9e00-84a8-84944f4d0558@gmail.com
Ответ на
Re: Transaction Size in PostgreSQL (Sivasamy Subramaniam)
Список
Дерево обсуждения
Transaction Size in PostgreSQL Sivasamy Subramaniam <sivasamyinfo@gmail.com>
Re: Transaction Size in PostgreSQL Mladen Gogala <gogala.mladen@gmail.com>
Re: Transaction Size in PostgreSQL "David G. Johnston" <david.g.johnston@gmail.com>
Re: Transaction Size in PostgreSQL Sivasamy Subramaniam <sivasamyinfo@gmail.com>
Re: Transaction Size in PostgreSQL Thomas Kellerer <shammat@gmx.net>
Re: Transaction Size in PostgreSQL Rui DeSousa <rui@crazybean.net>
Re: Transaction Size in PostgreSQL Mladen Gogala <gogala.mladen@gmail.com>
Re: Transaction Size in PostgreSQL "David G. Johnston" <david.g.johnston@gmail.com>
On 12/7/21 00:13, Sivasamy Subramaniam wrote: > Transaction size meaning, for example - any transaction over 1GB in > size? I am looking to set up an alert if any massive data changes are > happening in a single transaction. I can do it for long running > transactions or query but trying to figure out any easy way to > calculate the amount of data changes per transaction. You will have to build such tool into the application. Application will have to monitor pg_stat_xact_user_tables and send alert if the alert threshold is exceeded. That will make the application unnecessarily complex and will also impact the performance. This falls into the "no can do" category. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
В списке pgsql-admin по дате отправления
