>>> 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