Re: Invalid memory alloc request size

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>
To: Mahavir Trivedi <mahavir.trivedi@gmail.com>
Cc: pgsql-performance@postgresql.org
Date: 2012-10-31T10:28:50Z
Lists: pgsql-performance
Hello

2012/10/31 Mahavir Trivedi <mahavir.trivedi@gmail.com>:
> dear friends
>
> i have - sql file of size more than 1 gb
> when i execute it  then after some time "Invalid memory alloc request size
> 100234023 byte"   occcured
> what ' s problem that i don't know ?

there is hard-coded limit for memory request - for example - varlena
cannot be longer than 1GB, so this request was usually signal of some
error. Probably is too less for current computers.

Regards

Pavel Stěhule

>
>
>
> with thanks
> mahavir