Re: Large join runs out of memory in 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Sunday <sunday(at)csh(dot)rit(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Large join runs out of memory in 8.1
Date: 2006-03-14 20:56:51
Message-ID: 25667.1142369811@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Joe Sunday <sunday(at)csh(dot)rit(dot)edu> writes:
> 8.1 grows until it uses about 4 GB, at which point it dies with the
> following error:
> ERROR: out of memory
> DETAIL: Failed on request of size 8224.

This error should result in dumping a list of per-context memory usage
into the postmaster log ... could we have a look at that?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joe Sunday 2006-03-15 00:34:42 Re: Large join runs out of memory in 8.1
Previous Message Joe Sunday 2006-03-14 20:29:29 Large join runs out of memory in 8.1