| From: | Francisco Reyes <lists(at)stringsutils(dot)com> |
|---|---|
| To: | Vivek Khera <vivek(at)khera(dot)org> |
| Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_restore out of memory |
| Date: | 2007-06-18 18:10:58 |
| Message-ID: | cone.1182190258.198147.81364.5001@35st.simplicato.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vivek Khera writes:
> But that is a false assertion that the limit is 512Mb. On a random
> system of mine running FreeBSD/i386 it shows the default data limit
> as 1Gb, and on a random FreeBSD/amd64 box I see it at about 32Gb. I
> do no global tweaking of the size limits.
Understood.
I only showed "limit" because it was asked.
I already set /boot/loader.conf to 1600MB.
Also the error is about running out of memory when trying to allocate 84MB.
The default FreeBSD limit is 512MB so 84MB is well below that.
At this point this is basically stopping me from loading a table and so
far I have not been able to get any insight into how this could be fixed.
I wonder if there is any additional debuging I can turn on to help better
troubleshoot this.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Bartolome | 2007-06-18 18:13:29 | Re: pg_resetxlog command not found |
| Previous Message | Andrew Sullivan | 2007-06-18 18:09:28 | Re: [GENERAL] [pgsql-advocacy] [PERFORM] Postgres VS Oracle |