Hi all,
Recently, I have tried to install on Linux
( Mandrake 8.2 = kernel 2.4.18, PostgreSQL 7.2.1) in multi-users mode
some programs using psql and working well in single user mode.
I have a big problem with a program running in background
increasing more and more in a little time and taking all the memory (512 Mo
+ 1 Go of swap). In the same time, the postmaster use more and more
of CPU ... untill 100% and untill it was in conflict with kswapd ...
In short, the program use PQexec, PQgetvalue and PQclear after each
individual request or before a new request when the PQexec ask for
more than one tuple (or must do that).
Any help is welcome.
Regards,
--
Alain Lucari ( Eurlix)