The sql statement is select count(*) from table.
Forgot the count! :)
Girish
"Girish" <gbajaj@tietronixinc.com> wrote in message
news:awlY9.4$8A2.3628166@newssvr12.news.prodigy.com...
> 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
>
>
>