Postgres Pro
Downloads
Home   >   mailing lists

Out of memory when vacuuming - Mailing list pgsql-admin

From Szabolcs BALLA
Subject Out of memory when vacuuming
Date
Msg-id 44C5D8BB.9070508@confinsystems.com
Whole thread Raw
Responses Re: Out of memory when vacuuming  ("Aaron Bono" <postgresql@aranya.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Marco Bizzarri"
Date:
Subject: Checking what is the current query running
Next
From: "Shoaib Mir"
Date:
Subject: Re: problem backup/restore PSQL DB