pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Narayanan Subramaniam Iyer <bunix@rediffmail.com>
To: pgsql-performance@postgresql.org
Subject: Postgres server getting slow!!
Date: 29 Jan 2005 14:43:21 -0000
Message-ID: <20050129144321.18501.qmail@webmail18.rediffmail.com> (raw)

  
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

view thread (7+ messages)  latest in thread

Message-ID: <20050129144321.18501.qmail@webmail18.rediffmail.com>
Permalink:  ../20050129144321.18501.qmail@webmail18.rediffmail.com/
Also on:    postgresql.org/message-id/20050129144321.18501.qmail@webmail18.rediffmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: bunix@rediffmail.com
  Subject: Re: Postgres server getting slow!!
  In-Reply-To: <20050129144321.18501.qmail@webmail18.rediffmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox