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 |
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 |