| From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: sort_mem statistics ... |
| Date: | 2005-10-19 02:10:41 |
| Message-ID: | 20051018231026.D995@ganymede.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2005-10-19 02:23:04 | Re: sort_mem statistics ... |
| Previous Message | Christopher Kings-Lynne | 2005-10-19 02:07:56 | Re: sort_mem statistics ... |