pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Out of memory when vacuuming
2+ messages / 2 participants
[nested] [flat]

* Out of memory when vacuuming
@ 2006-07-25 08:39  Szabolcs BALLA <szballa@confinsystems.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Szabolcs BALLA @ 2006-07-25 08:39 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Out of memory when vacuuming
@ 2006-07-25 14:53  Aaron Bono <postgresql@aranya.com>
  parent: Szabolcs BALLA <szballa@confinsystems.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Aaron Bono @ 2006-07-25 14:53 UTC (permalink / raw)
  To: Szabolcs BALLA <szballa@confinsystems.com>; +Cc: pgsql-admin

On 7/25/06, Szabolcs BALLA <szballa@confinsystems.com> 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
==================================================================

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-07-25 14:53 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-25 08:39 Out of memory when vacuuming Szabolcs BALLA <szballa@confinsystems.com>
2006-07-25 14:53 ` Aaron Bono <postgresql@aranya.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox