Re: [GENERAL] out of memory
surabhi.ahuja wrote: hi i use postgres 8.0.0 i have a test program in c++, which tries to insert rows into the tables of my database. is there any way that i can check that there are no memory leaks etc happening. i ran valgrind on my test program that is not showing any mem leak, but are ther any other tools/ etc that i can use to double verufy it. Thanks, regards Surabhi May be you can try using -> http://www.andreasen.org/LeakTracer/ To be honest I have never used it. Many Thanks, Antonis ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Backend sent D message without prior T
Tom Lane wrote: > Antonis Antoniou <[EMAIL PROTECTED]> writes: > > I get the following message: > > Backend sent D message without prior T > > > Does anyone knows about this message? I am expecting to retrieve > > 2818510 records and am using PostgreSQL 7.1beta4. > > IIRC, this is a fairly common symptom of the frontend app running out > of memory --- libpq loses sync with what the backend is sending, and > it doesn't handle that very gracefully. > > I'd suggest using a cursor to retrieve the data in more manageable > chunks. > > regards, tom lane This is strange because the machine has 1GB of memory. Using the same database on PostgreSQL 7.0.2 and on a machine that has 500MB of memory the above query works fine. Regards Antonis
