Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump error - out of memory, Failed on request of size 536870912 - Mailing list pgsql-performance

From Stefan Kaltenbrunner
Subject Re: pg_dump error - out of memory, Failed on request of size 536870912
Date
Msg-id 48999A0E.7040007@kaltenbrunner.cc
Whole thread Raw
In response to Re: pg_dump error - out of memory, Failed on request of size 536870912  (Marcin Citowicki <marcin.citowicki@m4n.nl>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: pg_dump error - out of memory, Failed on request of size 536870912
Next
From: "Joshua Shanks"
Date:
Subject: query planner not using the correct index