Thanks joshua
i tried running vacuum command,
vacuum database as well as vacuum
but even after that querying the database , the memory shoots up
as i mentioned in the previous mail and never comes down.
Also the old pids of connections established remains even after the
connection is close
Thanks joshua
i tried running vacuum command,
vacuum database as well as vacuum
but even after that querying the database , the memory shoots up
as i mentioned in the previous mail and never comes down.
Also the old pids of connections established remains even after the
connection is closed
N S wrote:
I checked to find out the cause of the problem, ppp is disconnecting
properly and the user session is also closed smoothely.
But when a report query is run on the table containing 32500 records,
the memory shoots up from 50 MB to 500 MB(Total memory is 512 MB RAM).
After that the memory
I checked to find out the cause of the problem, ppp is disconnecting properly and the user session is also closed smoothely.
But when a report query is run on the table containing 32500 records,
the memory shoots up from 50 MB to 500 MB(Total memory is 512 MB RAM).
After that the memory usage neve
Thanks tom. I checked the client side software. The software closes connection when connected locally. But when connected through dialup,
this problem comes. I will check the ppp connection also.
Is there any method of killing old pids. And also any performance tuning to be done on postgresql.
"Narayanan Subramaniam Iyer" <[EMAIL PROTECTED]> writes:
> 1) When 3 or 4 clients connect to this server, the pids are created and
> those pids are not killed even after the client disconnects.
In that case your clients are not really disconnecting. Take a closer
look at your client-side software
Hi
i am running a High availability Postgresql server on redhat
linux 9. I am using NFS mount of data directory from a shared storage. The server was running without problems for last two
months. The server is connected to a dialin router where all my company units dialin and update the dat
