Re: PostgreSQL Database performance - Mailing list pgsql-general

From John R Pierce
Subject Re: PostgreSQL Database performance
Date
Msg-id c3e65fe0-9d9e-0b54-01c4-969e7f906576@hogranch.com
Whole thread Raw
In response to PostgreSQL Database performance  ("Pradeep" <pgundala@avineonindia.com>)
List pgsql-general
On 9/2/2016 8:38 PM, Pradeep wrote:
> ...  In task bar it is showing 2.7GB Utilization ...

odd, the task bar doesn't show any sort of memory utilization on any of
my windows systems.    are you referring instead to the Task Manager ?

Note the Windows Task Manager by default doesn't show shared memory
resources either, you'd have to go to the 'details...' view, then add a
column for 'Memory (shared working set)' to see this.

also note, the 'working set' is the memory thats actually being used,
not potentially allocated.   so even if you've told PG it can have 10GB
of shared buffers, if your database accesses since restarting the
database server have only touched 2GB of actual data, thats all that can
be 'working set'


--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PostgreSQL Database performance
Next
From: Geoff Winkless
Date:
Subject: joined tables with USING and GROUPBY on the USING() column