Re: BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;" - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;"
Date
Msg-id 4714E56A.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;"  ("ssurui" <ssurui@gmail.com>)
List pgsql-bugs
>>> On Tue, Oct 16, 2007 at  3:43 PM, in message
<200710162043.l9GKhGeF091013@wwwmaster.postgresql.org>, "ssurui"
<ssurui@gmail.com> wrote:=20
=20
> use top command observe the available memory
=20
top is not the best way to look at RAM usage.  Try free or other tools.
=20
> I find about 500MB memory is
> vanished after the SQL is executed.
=20
Meaning that it is used by the OS cache?  That would make sense,
given that you just read all the data pages for the table.
=20
-Kevin
=20

pgsql-bugs by date:

Previous
From: Douglas Toltzman
Date:
Subject: Re: BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;"
Next
From: "ssurui"
Date:
Subject: Re: BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;"