How to see how much memory is used ? - Mailing list pgsql-novice

From eurlix
Subject How to see how much memory is used ?
Date
Msg-id 20030406210828.213ee477.eurlix@libertysurf.fr
Whole thread Raw
List pgsql-novice
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)


pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: 7.2 search/replace pl/pgsql
Next
From: Josh Berkus
Date:
Subject: Re: 7.2 search/replace pl/pgsql