Correcting myself: Here is the version details template1=# select version(); version ---------------------------------------------------------------------------- --------------------------- PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3 20041212 (Red Hat 3.4.3-9.EL4) (1 row) Regards, Yogvinder Singh -----Original Message----- From: Yogvinder Singh [mailto:yogvinder@xxxxxxxxxxxx] Sent: January 08, 2009 4:37 PM To: 'Stefan Kaltenbrunner' Cc: 'David Fetter'; 'pgsql-general@xxxxxxxxxxxxxx' Subject: RE: RCA for MemoryContextAlloc: invalid request size(Known Issue) PostgreSQL Version PostgreSQL Release 7.3.19 installed on RHEL4. " It could simply be a query(or the OS) running out of memory." I have checked for the above situation. It's not the case. Moreover I have multiple same configuration servers. The same "select * from table" query runs on a much larger data set but is failing on a specific server only. I tried to select one particular row that 2 resulted in the same error. Regards, Yogvinder -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Stefan Kaltenbrunner Sent: January 08, 2009 3:50 PM To: Yogvinder Singh Cc: 'David Fetter'; pgsql-general@xxxxxxxxxxxxxx Subject: Re: RCA for MemoryContextAlloc: invalid request size(Known Issue) Yogvinder Singh wrote: > What I am looking for is the version in which this problem has been > resolved. > > I can't find it anywhere in the documentation. well there was by far not enough information in your original mail(not even the exact version you are on) to even verify that this is a data corruption issue. it could simply be a query(or the OS) running out of memory. As for what changed in the years since 7.3.0 was released simply read up on: http://www.postgresql.org/docs/current/static/release.html Stefan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general