Skip site navigation (1) Skip section navigation (2)

Re: Potential memory usage issue

From: David Brain <dbrain(at)bandwidth(dot)com>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Potential memory usage issue
Date: 2007-03-22 16:30:22
Message-ID: 4602AF1E.8000601@bandwidth.com (view raw or flat)
Thread:
Lists: pgsql-performance
Bill Moran wrote:

> 
> Install the pg_bufferstats contrib module and take a look at how shared
> memory is being use.  I like to use MRTG to graph shared buffer usage
> over time, but you can just do a SELECT count(*) WHERE NOT NULL to see
> how many buffers are actually in use.
> 

Can you explain what you'd use as a diagnostic on this - I just 
installed the module - but I'm not entirely clear as to what the output 
is actually showing me and/or what would be considered good or bad.

Thanks,

David.
-- 
David Brain - bandwidth.com
dbrain(at)bandwidth(dot)com

In response to

Responses

pgsql-performance by date

Next:From: Carlos MorenoDate: 2007-03-22 16:58:45
Subject: Re: Performance of count(*)
Previous:From: Mario WeilguniDate: 2007-03-22 16:20:02
Subject: Re: Performance of count(*)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group