Re: sort_mem statistics ... - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: sort_mem statistics ...
Date
Msg-id 20051018231026.D995@ganymede.hub.org
Whole thread Raw
In response to Re: sort_mem statistics ...  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: sort_mem statistics ...
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: sort_mem statistics ...
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: sort_mem statistics ...