The sql statement is select count(*) from table. Forgot the count! :)
Girish "Girish" <[EMAIL PROTECTED]> wrote in message news:awlY9.4$[EMAIL PROTECTED]... > Hello All, > > Ive recently installed postgres 7.3.1 on a Linux Box (Red Hat 8.0). Im > experiencing high memory usage by postgres.... heres what happens. > > I have a table in the database that has approximately 80,000 rows. I get > into psql on the command prompt and type in a simple select (*) from table; > > What happens next is that my memory (150M free) shoots down directly to > about 5M free! So I was assuming that postgres is taking up all that memory > for its buffers etc. > > Heres the catch - now when i exit pgsql - I see no memory being freed up! > Even when I shut down the database my memory is not freed up! I have about > 145 megs of memory just chewed by by postgres which has not been released > even after a database shutdown... I have to restart my machine to get back > all the memory... > > has anyone else seen this problem? > > Thanks, > Girish > > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
