Out of memory when vacuuming

From: Szabolcs BALLA <szballa(at)confinsystems(dot)com>
To: Postgresql Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Out of memory when vacuuming
Date: 2006-07-25 08:39:23
Message-ID: 44C5D8BB.9070508@confinsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I upgraded my server from 7.4.7 to 8.1.4 and when I want to run a vacuum
analyze verbose I've got this error message:
INFO: vacuuming "public.lgevents"
ERROR: out of memory
DETAIL: Failed on request of size 262143996.

My settings:
shared_buffers = 300000
temp_buffers = 256000
work_mem = 256000
maintenance_work_mem = 256000
max_fsm_pages = 250000
effective_cache_size = 614400

My server has 16Gbyte memory, and kernel.shmmax = 4294967295
Do you have any idea why I got this error message

Thanks,
Szabek

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shoaib Mir 2006-07-25 08:45:04 Re: problem backup/restore PSQL DB
Previous Message Marco Bizzarri 2006-07-25 08:15:25 Checking what is the current query running