Thread

1. postgres bombs for continous selects....

   Dronamraju Rajesh <drajesh80@yahoo.com> — 2000-12-25T12:24:49Z

   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/
   
   

2. Re: [BUGS] postgres bombs for continous selects....

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-12-25T17:47:11Z

   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