| From: | eurlix <eurlix(at)libertysurf(dot)fr> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | How to see how much memory is used ? |
| Date: | 2003-04-06 19:08:28 |
| Message-ID: | 20030406210828.213ee477.eurlix@libertysurf.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vittorio Zuccala' | 2003-04-06 20:22:27 | postgres start failed |
| Previous Message | Nabil Sayegh | 2003-04-06 19:08:04 | Re: 7.2 search/replace pl/pgsql |