Re: Huge amount of memory consumed during transaction

Поиск
Список
Период
Сортировка
От Erik Jones
Тема Re: Huge amount of memory consumed during transaction
Дата
Msg-id 69723004-A93C-41DE-BC69-57ABFAB059C2@myemma.com
обсуждение исходный текст
Ответ на Re: Huge amount of memory consumed during transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Huge amount of memory consumed during transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Oct 11, 2007, at 9:51 AM, Tom Lane wrote:

> henk de wit <henk53602@hotmail.com> writes:
>> ERROR:  out of memory
>> DETAIL:  Failed on request of size 4194304.
>
> This error should have produced a map of per-context memory use in the
> postmaster log.  Please show us that.
>
>             regards, tom lane

Tom, are there any docs anywhere that explain how to interpret those
per-context memory dumps?  For example, when I see an autovacuum
context listed is it safe to assume that the error came from an
autovac operation, etc.?

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com



В списке pgsql-performance по дате отправления:

Предыдущее
От: Benjamin Arai
Дата:
Сообщение: Re: [GENERAL] Slow TSearch2 performance for table with 1 million documents.
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Performance problems with prepared statements