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

From Christopher Kings-Lynne
Subject Re: sort_mem statistics ...
Date
Msg-id 4355AA7C.2090607@familyhealth.com.au
Whole thread Raw
In response to sort_mem statistics ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: sort_mem statistics ...
List pgsql-hackers
> 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



pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: 2nd try @NetBSD/2.0 Alpha
Next
From: "Marc G. Fournier"
Date:
Subject: Re: sort_mem statistics ...