| From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Transaction Size in PostgreSQL |
| Date: | 2021-12-07 06:41:13 |
| Message-ID: | 17b19213-1588-dca9-b009-8913b8d1401f@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Sivasamy Subramaniam schrieb am 07.12.2021 um 06:13:
> 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.
A long running transaction doesn't necessary mean it wrote "1GB" of data,
and a transaction that writes 1GB of data isn't necessarily a "long running"
transaction.
"Massive data changes" in a single transaction aren't really a problem.
In my experience a single transaction changing a lot of rows is more
efficient than multiple transactions changing fewer rows.
A long _running_ transaction - even if it only changed one row - is a much
bigger problem though.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rui DeSousa | 2021-12-07 06:59:34 | Re: Transaction Size in PostgreSQL |
| Previous Message | Sivasamy Subramaniam | 2021-12-07 05:13:45 | Re: Transaction Size in PostgreSQL |