| From: | Francisco Reyes <lists(at)stringsutils(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_restore out of memory |
| Date: | 2007-06-18 17:52:37 |
| Message-ID: | cone.1182189157.392756.81364.5001@35st.simplicato.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2007-06-18 17:57:06 | Re: [pgsql-advocacy] [PERFORM] Postgres VS Oracle |
| Previous Message | Joshua D. Drake | 2007-06-18 17:51:11 | Re: [pgsql-advocacy] [PERFORM] Postgres VS Oracle |