| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Jairo Carrillo <carsofteu(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5671: ERROR: out of memory |
| Date: | 2010-09-23 00:57:47 |
| Message-ID: | AANLkTikVaGtfsgfb4tnraWN8utCK1eR97RJEoEAwpeuS@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, Sep 21, 2010 at 4:54 PM, Jairo Carrillo <carsofteu(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5671
> Logged by: Jairo Carrillo
> Email address: carsofteu(at)gmail(dot)com
> PostgreSQL version: 8.4
> Operating system: windows server 2003 r2
> Description: ERROR: out of memory
> Details:
>
> INFO: vacuuming "public.localizacion"
>>> ERROR: out of memory
>>> DETAIL: Failed on request of size 1048575996.
>>>
>>> ERROR: out of memory
>>> DETAIL: Failed on request of size 1048575996.
I'm not sure if there's a bug here or not, but it sounds like you're
out of memory. :-)
What is the value of maintenance_work_mem? How large is the table?
How much memory do you have on your machine? Exactly which 8.4
release are you running?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-09-23 01:00:01 | Re: BUG #5669: server process was terminated by exception 0xC0000005 |
| Previous Message | Tom Lane | 2010-09-22 17:54:22 | Re: BUG #5669: server process was terminated by exception 0xC0000005 |