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?
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 Walter||Date: 2008-10-14 16:41:59|
|Subject: Upgrade in same major version|
|Previous:||From: Tom Lane||Date: 2008-10-14 12:56:56|
|Subject: Re: postgres seems to ignore log_min_duration_statement |