Re: Huge amount of memory consumed during transaction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Erik Jones <erik(at)myemma(dot)com>
Cc: henk de wit <henk53602(at)hotmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Huge amount of memory consumed during transaction
Date: 2007-10-11 17:49:43
Message-ID: 2507.1192124983@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Erik Jones <erik(at)myemma(dot)com> writes:
> Tom, are there any docs anywhere that explain how to interpret those =20
> per-context memory dumps?

No, not really. What you have to do is grovel around in the code and
see where contexts with particular names might get created.

> For example, when I see an autovacuum =20
> context listed is it safe to assume that the error came from an =20
> autovac operation, etc.?

Probably, but I haven't looked.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew - Supernews 2007-10-11 18:28:02 Re: Performance problems with prepared statements
Previous Message Merlin Moncure 2007-10-11 17:28:51 Re: Performance problems with prepared statements