Re: Out of memory when vacuuming

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 7/25/06, Szabolcs BALLA <szballa@xxxxxxxxxxxxxxxxx> wrote:
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?

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
==================================================================

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux