| 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-26 03:06:35 |
| Message-ID: | cone.1182827195.281743.14766.1000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vivek Khera writes:
> you set your maxdsize to the same as on i386?
On the AMD64 I have /boot/loader.conf as
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
In i386 I believe I had set
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
kern.maxdsiz="1600MB"
kern.dfldsiz="1600MB"
kern.maxssiz="512MB"
In another machine, my laptop, I did not even increase anything. Used
defaults straight from postgresql.conf and the large columns loaded fine.
All 4 trouble rows were above 80MB.
Limits compared.
AMD64
limit
cputime unlimited
filesize unlimited
datasize 33554432 kbytes
stacksize 524288 kbytes
coredumpsize unlimited
memoryuse unlimited
vmemoryuse unlimited
descriptors 11095
memorylocked unlimited
maxproc 5547
sbsize unlimited
Limit in i386 was
Report from limit:
cputime unlimited
filesize unlimited
datasize 2097152 kbytes
stacksize 131072 kbytes
coredumpsize unlimited
memoryuse unlimited
vmemoryuse unlimited
descriptors 11095
memorylocked unlimited
maxproc 5547
sbsize unlimited
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 金星星 | 2007-06-26 03:18:10 | data partitions across different nodes |
| Previous Message | Vivek Khera | 2007-06-26 02:36:45 | Re: pg_restore out of memory |