Re: Out of memory when vacuuming
| От | Aaron Bono |
|---|---|
| Тема | Re: Out of memory when vacuuming |
| Дата | |
| Msg-id | bf05e51c0607250753t9680f5dm86ce82d80c5eafe5@mail.gmail.com обсуждение исходный текст |
| Ответ на | Out of memory when vacuuming (Szabolcs BALLA <szballa@confinsystems.com>) |
| Список | pgsql-admin |
On 7/25/06, Szabolcs BALLA <szballa@confinsystems.com> wrote:
What OS are you using?
If you are using Linux, you may want to check the memory limits for the postgres user? Try a "ulimit" on postgres. I had similar problems on my Linux server.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
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
What OS are you using?
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
В списке pgsql-admin по дате отправления: