question about memory usage

Поиск
Список
Период
Сортировка
От klo uo
Тема question about memory usage
Дата
Msg-id CAA-8Ld91zXGE=Mtq0WE7X35GgJ+-zn1-bVtnPUdh8Yjca1bUoQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: question about memory usage  (Bill Moran <wmoran@potentialtech.com>)
Список 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
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Anil Menon
Дата:
Сообщение: Re: Referencing serial col's sequence for insert
Следующее
От: Ramesh T
Дата:
Сообщение: Fwd: Need r_constraint_name