Re: Out of memory (failed on request)

Hello HappyGirl84,

This list is for pgAdmin, the GUI administrative tool for PostgreSQL.
For questions such as yours, which relate to Postgres itself, you'd
better post to the pgsql-general list.

May be this will help:

Check configuration parameter 'maintenance_work_mem' by issuing
following in the query window:

show maintenance_work_mem

or

select * from pg_settings where name='maintenance_work_mem'

If it differs from default (16MB), try to lower the value, see here:
http://www.postgresql.org/docs/current/static/config-setting.html#CONFIG-SETTING-CONFIGURATION-FILE
http://www.postgresql.org/docs/current/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY

But note that in most cases it is sufficent to rely on autovacuum
feature, see here:
http://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM

Thursday, April 24, 2014, 3:52:18 AM, you wrote:

H> Im running a PostgreSQL database (pokerdatabase with HoldemManager) and
H> trying to vacuum it with pgadmin III, but I keep getting the same error
H> message (out of memory, detail: Failed on request of size 268435456).

H> I can read that I should try lower the "working memory", but how do I do
H> that? I got no skills on databases or postgresql :(

H> Ive attached a screenshot of the error.

H> untitled22.png
H> <http://postgresql.1045698.n5.nabble.com/file/n5801327/untitled22.png>

--
Best regards,
J.F.