Oliver <ofabelo@gmail.com> wrote:
> DB hasn't activity now because it is a new instance, top command
> indicates only 350MB of used memory .. I understand that
> postgresql could reach until 2GB of server memory as total,
> correct?
It's usually much better to copy/paste what you're talking about
than to just refer to it. On the varieties of Linux I use, if
you're talking about the virtual memory, the full size should be
included there for every postgres backend process which has
connected to it, while only the portion which has been accessed by
each backend will be included in its shared or resident memory.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company