Thread: postgres bombs for continous selects....

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/

Dronamraju Rajesh <drajesh80@yahoo.com> writes:
> Is it a bug in memory management of postgres ????

Possibly, but you're going to have to get a lot more specific about
what you're doing and seeing before anyone will be able to tell.

            regards, tom lane