On Wed, 23 Jul 2014 00:16:47 +0200 klo uo <klo...@gmail.com> wrote: > > 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?
I'm not an expert on the Windows version, so I could be off-base, but the POSIX versions of Postgres allocate shared_buffers worth of memory at startup and lock it for exclusive use by Postgres. Do you have shared_buffers set to around 1G, perhaps? -- Bill Moran <wmo...@potentialtech.com> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
