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?

Thanks with regards from Maurice.

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