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