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.