pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOut 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>
2006-07-25 14:53 ` Re: Out of memory when vacuuming Aaron Bono <postgresql@aranya.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 08:39 Out of memory when vacuuming Szabolcs BALLA <szballa@confinsystems.com>
@ 2006-07-25 14:53 ` Aaron Bono <postgresql@aranya.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