sort_mem logging when exceeded ...

Started by The Hermit Hackeralmost 20 years ago2 messageshackers

scrappy@hub.org

almost 20 years ago

I thought we added something in 8.1 for doing this, but can't seem to find
anything ... where it reports how much memory is/was needed to do the sort
to the logs ...

Is that something for 8.2, that didn't get into 8.1? Or am I looking at
the wrong docs?

Thx

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org MSN . scrappy@hub.org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664

Tom Lane

tgl@sss.pgh.pa.us

almost 20 years ago

In reply to: The Hermit Hacker (#1)

Re: sort_mem logging when exceeded ...

"Marc G. Fournier" <scrappy@postgresql.org> writes:

I thought we added something in 8.1 for doing this, but can't seem to find
anything ... where it reports how much memory is/was needed to do the sort
to the logs ...

trace_sort

regards, tom lane