Re: out of memory error when running DB maintenance

Le 18/12/2010 06:14, Ben Deneweth a écrit :
> I have a DB taking up 220gb of a 300gb drive so I purged some old data
> from it.  When I try to vaccum/analyze using pgAdmin III I keep getting
> an out of memory error.  I am running Windows Vista 64 bit with 8gb of
> RAM and I have change the postgresql.conf file variables to the following:
> 
> #custom_variable_classes = ''        # list of custom variable class names
> shared_buffers = 1024MB
> effective_cache_size = 2048MB
> work_mem = 64MB
> maintenance_work_mem = 1024MB
> commit_delay = 10000
> checkpoint_segments = 128
> checkpoint_completion_target = 0.9
> wal_buffers = 2MB
> 
> Any ideas on how I can avoid running out of memory and run a successful
> vacuum/analyze?
> 

Can you show us the complete error message? and tell us what PostgreSQL
release you use?


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com