Hi,

Sorry to bring bad news but it seems that the postgresql daemon is leaking
memory when building indices.
(When using electric fence it takes long enough to notice -:))

Anybody want to recommend a good freeware tool which helps to find memory
leaks?

Thanks with regards from Maurice.



Wed, 1 Apr 1998 17:01:41 +0200
"Maurice Gittens" <mgittens@gits.nl>
Memory leak while creating indices?
> 
> Hi,
> 
> Sorry to bring bad news but it seems that the postgresql daemon is leaking
> memory when building indices.
> (When using electric fence it takes long enough to notice -:))
> 
> Anybody want to recommend a good freeware tool which helps to find memory
> leaks?

Yea, as I reported earlier, it is probably all from the same place.  I
used a pginterface C file do show it.  I think we need Purify.


---------------------------------------------------------------------------

/*
 * pgnulltest.c
 *
*/

#include <stdio.h>
#include <signal.h>
#include <time.h>
#include <halt.h>
#include <postgres.h>
#include <libpq-fe.h>
#include <pginterface.h>

int main(int argc, char **argv)
{
	char query[4000];
	
	if (argc != 2)
		halt("Usage:  %s database\n",argv[0]);

	connectdb(argv[1],NULL,NULL,NULL,NULL);

	while (1)
	{
		sprintf(query,"select * from test;");
		doquery(query);
		sprintf(query,"update test set x=3;");
		doquery(query);
	}
	disconnectdb();
	return 0;
}



-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Wed, 1 Apr 1998 11:10:26 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Memory leak while creating indices?