Re: [HACKERS] Figuring out shared buffer pressure

2012-05-31 Thread Bruce Momjian
On Wed, May 30, 2012 at 05:55:07PM -0400, Bruce Momjian wrote: Seems buffers_alloc is the number of calls to StrategyGetBuffer(), which tells how many time we have requested a buffer.  Not sure how that helps measure buffer pressure. Once the linked list is empty, every request for a

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-31 Thread Cédric Villemain
Le jeudi 31 mai 2012 19:11:07, Bruce Momjian a écrit : On Wed, May 30, 2012 at 05:55:07PM -0400, Bruce Momjian wrote: Seems buffers_alloc is the number of calls to StrategyGetBuffer(), which tells how many time we have requested a buffer. Not sure how that helps measure buffer

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-31 Thread Daniel Farina
On Thu, May 31, 2012 at 10:11 AM, Bruce Momjian br...@momjian.us wrote: However, this doesn't help people configure shared buffers larger (e.g. 35%) if their working set is larger.  Right now, I don't see how a user would know this is happening.  On the flip side, they might have a smaller

[HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Bruce Momjian
As part of a blog, I started looking at how a user could measure the pressure on shared buffers, e.g. how much are they being used, recycled, etc. They way you normally do it on older operating systems is to see how many buffers on the free list (about to be reused) are reclaimed as needed ---

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Jeff Janes
On Wed, May 30, 2012 at 9:56 AM, Bruce Momjian br...@momjian.us wrote: As part of a blog, I started looking at how a user could measure the pressure on shared buffers, e.g. how much are they being used, recycled, etc. They way you normally do it on older operating systems is to see how many

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Bruce Momjian
On Wed, May 30, 2012 at 10:38:10AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 9:56 AM, Bruce Momjian br...@momjian.us wrote: As part of a blog, I started looking at how a user could measure the pressure on shared buffers, e.g. how much are they being used, recycled, etc. They way

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Jeff Janes
On Wed, May 30, 2012 at 10:57 AM, Bruce Momjian br...@momjian.us wrote: On Wed, May 30, 2012 at 10:38:10AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 9:56 AM, Bruce Momjian br...@momjian.us wrote: As part of a blog, I started looking at how a user could measure the pressure on shared

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Bruce Momjian
On Wed, May 30, 2012 at 11:06:45AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 10:57 AM, Bruce Momjian br...@momjian.us wrote: On Wed, May 30, 2012 at 10:38:10AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 9:56 AM, Bruce Momjian br...@momjian.us wrote: As part of a blog, I

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Jeff Janes
On Wed, May 30, 2012 at 11:23 AM, Bruce Momjian br...@momjian.us wrote: On Wed, May 30, 2012 at 11:06:45AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 10:57 AM, Bruce Momjian br...@momjian.us wrote: On Wed, May 30, 2012 at 10:38:10AM -0700, Jeff Janes wrote: Isn't that what the

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Bruce Momjian
On Wed, May 30, 2012 at 11:51:23AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 11:23 AM, Bruce Momjian br...@momjian.us wrote: On Wed, May 30, 2012 at 11:06:45AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 10:57 AM, Bruce Momjian br...@momjian.us wrote: On Wed, May 30, 2012 at

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Jeff Janes
On Wed, May 30, 2012 at 2:55 PM, Bruce Momjian br...@momjian.us wrote: On Wed, May 30, 2012 at 11:51:23AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 11:23 AM, Bruce Momjian br...@momjian.us wrote: On Wed, May 30, 2012 at 11:06:45AM -0700, Jeff Janes wrote: On Wed, May 30, 2012 at 10:57