Re: pg_restore out of memory

Alvaro Herrera writes:

>> The OS size is 1.6GB, but today I am going to try increasing kern.maxssiz.
>> Vivek recommended increasing it

kern.maxssiz is the maximum stack size.
Increased to 512MB. Didn't help.


> The problem is probably the ulimit.

I did a shell script which continuously did ps auxwm |head -n >>SizePS.txt
as I tried to load the data using the copy command.

>> >In short, you need a bigger per-process memory allowance.

The program crashed right after it reached 895704 (874MB) in size and 400212
(390MB) resident.

> Can you send the program along?  And the table definition (including
> indexes, etc)?

The problem, as far as I can tell, is the data.
I wrote the program to see if the problem was only with the "copy from".
The program without the data is not likely to be of much use.
I will see if I can get authorization to provide the data (1 record) and the
table structure. The data is about 60MB compressed though. The file was
created from using copy to, so to load it I just use
"copy <table> from '<file>'"