question about memory usage

From: klo uo <klonuo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: question about memory usage
Date: 2014-07-22 22:16:47
Message-ID: CAA-8Ld91zXGE=Mtq0WE7X35GgJ+-zn1-bVtnPUdh8Yjca1bUoQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
image/png 26.0 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2014-07-23 02:26:36 Re: check database integrity
Previous Message David Johnston 2014-07-22 18:24:30 Re: Referencing serial col's sequence for insert