Re: sort_mem statistics ...

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: sort_mem statistics ...
Date: 2005-10-19 02:07:56
Message-ID: 4355AA7C.2090607@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-10-19 02:10:41 Re: sort_mem statistics ...
Previous Message Larry Rosenman 2005-10-19 01:54:08 Re: 2nd try @NetBSD/2.0 Alpha