postgres bombs for continous selects.... - Mailing list pgsql-admin

From Dronamraju Rajesh
Subject postgres bombs for continous selects....
Date
Msg-id 20001225122449.3302.qmail@web9614.mail.yahoo.com
Whole thread Raw
Responses Re: [BUGS] postgres bombs for continous selects....  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi there,

     I am using postgres6.5.3, 7.0.2, 7.0.3 versions
in three different systems. All the systems serve
continous web requests that query postgres for data.
It is around 25 - 30 requests per second. The database
is also not big. Infact it is only 1Mb with 12 tables.
Postgres process is increasing in size and then making
the system down after 40 minutes. If i vacuum
postmaster every half an hour, then postgres is
running properly.

   Iam using Linux6.2 and started postmaster with the
command postmaster -i -N 512 -B 1024
>>/usr/local/pgsql/logs/server.log 2>&1 &

Is it a bug in memory management of postgres ????

any help is appreciated.

Regards
Rajesh.

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Is that a bug?
Next
From: jmoschet@netscape.net
Date:
Subject: Permissions on Stored Procedures