Re: [PERFORM] Postgres server getting slow!!

2005-01-31 Thread N S
closed. Will backing up the complete database, dropping and recreating can make any difference. Kindly suggest Thanks in advance regards N S      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.

Re: [PERFORM] Postgres server getting slow!!

2005-01-31 Thread N S
closed. Will backing up the complete database, dropping and recreating can make any difference. Kindly suggest Thanks in advance regards N S On Mon, 31 Jan 2005 Joshua D.Drake wrote : >N S wrote: > >>I checked to find out the cause of the problem, ppp is disconnecting properly

Re: [PERFORM] Postgres server getting slow!!

2005-01-30 Thread N S
/data contains 700 MB of data. Which all paramters are required to be increased in postgresq.conf. Regds N S On Sun, 30 Jan 2005 N S wrote : > > >Thanks tom. I checked the client side software. The software closes connection when connected locally. But when connected through dial

Re: [PERFORM] Postgres server getting slow!!

2005-01-29 Thread N S
  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.