Thread

1. Memory leak while creating indices?

   Maurice Gittens <mgittens@gits.nl> — 1998-04-01T15:01:41Z

   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.
   
   
   
   

2. Re: [HACKERS] Memory leak while creating indices?

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-04-01T16:10:26Z

   > 
   > 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)