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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
