Search Postgresql Archives

Re: PostgreSQL Database performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux