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(at)candle(dot)pha(dot)pa(dot)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)