question about memory usage - Mailing list pgsql-general

From klo uo
Subject question about memory usage
Date
Msg-id CAA-8Ld91zXGE=Mtq0WE7X35GgJ+-zn1-bVtnPUdh8Yjca1bUoQ@mail.gmail.com
Whole thread Raw
Responses Re: question about memory usage
List pgsql-general
Hi,

I run Windows and I started using 64 bit PostgreSQL 9.3 a month ago.
I have several PostGIS databases on localhost, with these statistics:

===============================================================
                     Xact
         Xact        Rolled  Blocks  Blocks   Tuples    Tuples
Size     Committed   Back    Read    Hit      Returned  Fetched
---------------------------------------------------------------
1839 MB      52290    105      7593  1962771  27426946   502140
 312 MB         23      0       177     1671      2796      902
 340 MB         31      0       242     2867      4138     1426
  69 MB      40796     21      7996  2019122  27852048   463184
  71 MB         23      0       176     1674      2101      914
 663 MB         37      0       328     2825     14240     1481
6298 kB      51680      0       950  1431658  23355239   291505
===============================================================


Looking in process explorer, I see unusual size for postgres server process, i.e. working set reported around 1GB: http://i.imgur.com/HmkvFLM.png (same in attachment)

I also use SqlExpress server with several databases (including spatial) but that doesn't go above 100MB in Private Bytes and around 1 MB in Working Set.

I wanted to ask, if this is normal, or there is some problem with my server setting?


Thanks
Attachment

pgsql-general by date:

Previous
From: Anil Menon
Date:
Subject: Re: Referencing serial col's sequence for insert
Next
From: Ramesh T
Date:
Subject: Fwd: Need r_constraint_name