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. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
