Re: pg_restore out of memory

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