Hello 2012/10/31 Mahavir Trivedi <mahavir.trivedi@xxxxxxxxx>: > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance