Re: An out of memory error when doing a vacuum full

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sean Shanny <shannyconsulting(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: An out of memory error when doing a vacuum full
Date: 2003-12-29 16:45:04
Message-ID: 15451.1072716304@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sean Shanny <shannyconsulting(at)earthlink(dot)net> writes:
> Does anyone have an explanation as to why this might occur?

What have you got vacuum_mem set to? Also, what ulimit settings is the
postmaster running under? (I'm wondering exactly how large the backend
process has grown when it gets the failure.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-29 16:49:56 Re: Out of memory error when doing an update with IN clause
Previous Message Fernando Schapachnik 2003-12-29 16:41:21 Re: An out of memory error when doing a vacuum full