What constitutes a transaction when reading BLOBs?

From: Irina Sourikova <irina(at)bnl(dot)gov>
To: pgsql-admin(at)postgresql(dot)org
Subject: What constitutes a transaction when reading BLOBs?
Date: 2008-10-14 15:26:48
Message-ID: 48F4BA38.8030900@bnl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bnl(dot)gov

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-10-14 16:41:59 Upgrade in same major version
Previous Message Tom Lane 2008-10-14 12:56:56 Re: postgres seems to ignore log_min_duration_statement