Re: [HACKERS] 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)