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

Re: buffer freelist

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Halley Pacheco de Oliveira <halleypo(at)yahoo(dot)com(dot)br>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: buffer freelist
Date: 2005-07-07 15:05:43
Message-ID: 20050707150543.GC7157@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-docs
On Thu, Jul 07, 2005 at 07:29:33AM -0300, Halley Pacheco de Oliveira wrote:
> PostgreSQL 8.0.3 Documentation
> Chapter 16. Server Run-time Environment
> 16.4. Run-time Configuration
> 
> debug_shared_buffers (integer)
> 
> Number of seconds between buffer freelist reports. If set greater than
> zero, emit freelist statistics to the log every so many seconds. Zero
> (the default) disables reporting. 
> 
> What is a buffer freelist? I can't find a definition, and I can't
> translate if I don't understand.
> 
> Is it a list of free buffers as it seems to be? What is a free buffer?

Yes, a list of free buffers.  A free buffer is a buffer that's not used
:-)  This is mainly a debugging option -- I don't think it would have
much use for regular users.  Then again, you may want to know how well
is your shared_buffers setting defined -- if too low, then freelists
will be short.

I doubt this can really be used to improve performance.

Note that this option disappeared in current in-development code ...

-- 
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"La realidad se compone de muchos sueños, todos ellos diferentes,
pero en cierto aspecto, parecidos..." (Yo, hablando de sueños eróticos)

In response to

pgsql-docs by date

Next:From: szcDate: 2005-07-09 09:15:04
Subject:
Previous:From: Halley Pacheco de OliveiraDate: 2005-07-07 10:29:33
Subject: buffer freelist

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