Обсуждение: sort_mem logging when exceeded ...

Поиск
Список
Период
Сортировка

sort_mem logging when exceeded ...

От
"Marc G. Fournier"
Дата:
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


Re: sort_mem logging when exceeded ...

От
Tom Lane
Дата:
"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