Re: sort_mem statistics ...

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: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664