Re: Invalid memory alloc request size

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Mahavir Trivedi <mahavir(dot)trivedi(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Invalid memory alloc request size
Date: 2012-10-31 10:28:50
Message-ID: CAFj8pRADpXxLUr-Y6KyZbC7GAutZWwcY3V6jPdVuTP8E93ndVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello

2012/10/31 Mahavir Trivedi <mahavir(dot)trivedi(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Samuel Gendler 2012-10-31 10:34:25 Re: Invalid memory alloc request size
Previous Message Mahavir Trivedi 2012-10-31 10:24:45 Invalid memory alloc request size