Search Postgresql Archives

question about memory usage

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: Clipboard01.png
Description: PNG image


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux