From: | John Cole <john(dot)cole(at)uai(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Out of memory on vacuum analyze |
Date: | 2007-02-19 18:47:01 |
Message-ID: | 76758090F8686C47A44B6FF52514A1D307909AE1@hermes.uai.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a large table (~55 million rows) and I'm trying to create an index
and vacuum analyze it. The index has now been created, but the vacuum
analyze is failing with the following error:
ERROR: out of memory
DETAIL: Failed on request of size 943718400.
I've played with several settings, but I'm not sure what I need to set to
get this to operate. I'm running on a dual Quad core system with 4GB of
memory and Postgresql 8.2.3 on W2K3 Server R2 32bit.
Maintenance_work_mem is 900MB
Max_stack_depth is 3MB
Shared_buffers is 900MB
Temp_buffers is 32MB
Work_mem is 16MB
Max_fsm_pages is 204800
Max_connections is 50
Any help would be greatly appreciated.
Thanks,
John Cole
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.2/692 - Release Date: 2/18/2007
4:35 PM
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2007-02-19 18:52:51 | Re: complex referential integrity constraints |
Previous Message | Bruno Wolff III | 2007-02-19 18:41:11 | Re: Why *exactly* is date_trunc() not immutable ? |