Re: pg_restore out of memory - Mailing list pgsql-general

From Francisco Reyes
Subject Re: pg_restore out of memory
Date
Msg-id cone.1182189157.392756.81364.5001@35st.simplicato.com
Whole thread Raw
In response to pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Tom Lane writes:

> If that actually is the length of the line, the only answer is to raise
> the memory ulimit setting the postmaster runs under.

Did another test to try to see if the problem is that row or the size of the
row.

Another record of greater size also failed.

Any ideas what this 84MB limit could be from?
I have shared_buffers at 450MB
maintenance_work_mem = 64MB (which I increased to 100MB with the same
result)

OS limit for applications at 1.6GB.
Also when I start postgresql I see several postgresql processes using 400M+
so I don't see how it could be the Os limit.


pgsql-general by date:

Previous
From: Guy Rouillier
Date:
Subject: Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle
Next
From: "Jonah H. Harris"
Date:
Subject: Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle