Isn't that what pg_stat_database reports with its xact_commit and
xact_rollback values?
On Wed, 19 Oct 2005, Christopher Kings-Lynne wrote:
do we maintain anything anywhere for this? mainly, some way of determining
# of 'sorts to disk' vs 'sort in memory', to determine whether or not
sort_mem is set to a good value?
I don't think there is currently, but wondering how hard it would be to get
something like this added ... ?
While on the subject of stats - is there any way to count the total
transactions that have occurred since the last stats reset? Do we track that
single number somewhere?
Chris
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly