From: | "Girish" <gbajaj(at)tietronixinc(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Memory Leaks/Problems |
Date: | 2003-01-25 01:26:06 |
Message-ID: | OIlY9.11$E53.5793965@newssvr12.news.prodigy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
The sql statement is select count(*) from table.
Forgot the count! :)
Girish
"Girish" <gbajaj(at)tietronixinc(dot)com> wrote in message
news:awlY9(dot)4$8A2(dot)3628166(at)newssvr12(dot)news(dot)prodigy(dot)com(dot)(dot)(dot)
> 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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah. | 2003-01-25 04:56:14 | VACUUM warning message. |
Previous Message | Oscar Miranda | 2003-01-24 16:39:12 | help about postgres |