Re: pg_dump error - out of memory, Failed on request of size 536870912

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Marcin Citowicki <marcin(dot)citowicki(at)m4n(dot)nl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_dump error - out of memory, Failed on request of size 536870912
Date: 2008-08-06 12:33:18
Message-ID: 48999A0E.7040007@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Marcin Citowicki wrote:
> Hello,
>
> I forgot to add - all those 'out of memory' errors happen when backup db
> is trying to create index. Every 'CREATE INDEX' operation is followed by
> 'out of memory' error.

are you sure that your OS (or ulimit) is able to support a
maintenance_work_setting that large ? - try reducing to a say 128MB for
a start and try again.

Stefan

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua Shanks 2008-08-06 21:35:01 query planner not using the correct index
Previous Message Pavel Stehule 2008-08-06 12:21:15 Re: pg_dump error - out of memory, Failed on request of size 536870912