Postgres server getting slow!!

From: "Narayanan Subramaniam Iyer" <bunix(at)rediffmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Postgres server getting slow!!
Date: 2005-01-29 14:43:21
Message-ID: 20050129144321.18501.qmail@webmail18.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

 
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 database.
Concurrently i have some 25 to 50 connections at peak hours.

Following are the problems i am facing

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.
after sometimes some 10 to 20 pids gets created and postgres reject client connections.

2) After one or two concurrent connections, the server slows down.
The postmaster occupies more than 90% of the memory.

3) Even when restarting server, after one or two connection from clients, the pids start increasing automatically to 10 or 13. This again slows down the server.

Please help me to sort out this issue

Thanks in advance .

Regards

N S

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-01-29 15:51:18 Re: Postgres server getting slow!!
Previous Message William Yu 2005-01-29 08:22:14 Re: PostgreSQL clustering VS MySQL clustering