Re: sort_mem statistics ...

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: sort_mem statistics ...
Дата
Msg-id 20051018231026.D995@ganymede.hub.org
обсуждение исходный текст
Ответ на Re: sort_mem statistics ...  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: sort_mem statistics ...  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: sort_mem statistics ...
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: sort_mem statistics ...