Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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 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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group