Memory usage question - Mailing list pgsql-general

From Alessandro Baretta
Subject Memory usage question
Date
Msg-id 3D3B485D.3080406@baretta.com
Whole thread Raw
Responses Re: Memory usage question  (Ralph Graulich <maillist@shauny.de>)
List pgsql-general
I have just run a seqscan query on a fairly large table
(1.8Mrows, ca 40MB). I have a 256MB machine, so I expected
the postgres process to take up approximately that amount of
memory. On the other hand, observing top, I noticed postgres
was consistently below 4000KB. What does that mean? Isn't
postgres supposed to cache most of the database in memory,
so as to limit disk access?

Alex


pgsql-general by date:

Previous
From: Ewald Geschwinde
Date:
Subject: Re: pg_dump: PG 7.0 -> PG 7.2.1
Next
From: Ralph Graulich
Date:
Subject: Re: Memory usage question