| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Ben Deneweth <ben(dot)deneweth(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: out of memory error when running DB maintenance |
| Date: | 2010-12-18 07:08:45 |
| Message-ID: | 4D0C5DFD.9000509@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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?
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2010-12-18 10:58:32 | Re: how to set tab size on sql editor |
| Previous Message | Guillaume Lelarge | 2010-12-18 07:06:54 | Re: how to set tab size on sql editor |