What constitutes a transaction when reading BLOBs? - Mailing list pgsql-admin

From Irina Sourikova
Subject What constitutes a transaction when reading BLOBs?
Date
Msg-id 48F4BA38.8030900@bnl.gov
Whole thread Raw
List pgsql-admin
Hi,

We have a read-only database with large BLOBs, and the field
'xact_commit' of pg_stat_database is incremented by thousands every minute.
The number of concurrent connections is about 5-10.
What is considered a transaction in general and when BLOBs are involved
and how does it affect the autovacuum?

Thank you,
Irina

--
Irina Sourikova
Brookhaven National Laboratory      phone: +1-631-344-3776
Physics Department, Bldg 510 C      fax:   +1-631-344-3253
Upton, NY 11973-5000                email: irina@bnl.gov



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres seems to ignore log_min_duration_statement
Next
From: Carol Walter
Date:
Subject: Upgrade in same major version