Re: [HACKERS] Figuring out shared buffer pressure

2012-05-31 Thread Daniel Farina
On Thu, May 31, 2012 at 10:11 AM, Bruce Momjian 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 working set than

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 b

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 r

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Jeff Janes
On Wed, May 30, 2012 at 2:55 PM, Bruce Momjian 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 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 wro

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 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 wrote: > >> > On Wed, May 30, 2012 at 10:38:10AM -0700, Jeff Ja

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Jeff Janes
On Wed, May 30, 2012 at 11:23 AM, Bruce Momjian 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 wrote: >> > On Wed, May 30, 2012 at 10:38:10AM -0700, Jeff Janes wrote: >> >> >> >> Isn't that what the buffers_alloc from pg_sta

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 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 wrote: > >> > As part of a blog, I started looking at how a user

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Jeff Janes
On Wed, May 30, 2012 at 10:57 AM, Bruce Momjian 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 wrote: >> > As part of a blog, I started looking at how a user could measure the >> > pressure on shared buffers, e.g. how much ar

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 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 no

Re: [HACKERS] Figuring out shared buffer pressure

2012-05-30 Thread Jeff Janes
On Wed, May 30, 2012 at 9:56 AM, Bruce Momjian 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 buffers on

[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 --- tha