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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to