Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge amount of memory consumed during transaction - Mailing list pgsql-performance

From Erik Jones
Subject Re: Huge amount of memory consumed during transaction
Date
Msg-id 69723004-A93C-41DE-BC69-57ABFAB059C2@myemma.com
Whole thread Raw
In response to Re: Huge amount of memory consumed during transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Huge amount of memory consumed during transaction
List pgsql-performance
Tree view 
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 by date:

Previous
From: Benjamin Arai
Date:
Subject: Re: [GENERAL] Slow TSearch2 performance for table with 1 million documents.
Next
From: "Merlin Moncure"
Date:
Subject: Re: Performance problems with prepared statements