Re: patch for new feature: Buffer Cache Hibernation

From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Mitsuru IWASAKI <iwasaki(at)jp(dot)freebsd(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: patch for new feature: Buffer Cache Hibernation
Date: 2011-05-04 16:07:44
Message-ID: BANLkTimg7NcSzp0j-E=42A0O=GyhCh_BfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2011/5/4 Greg Stark <gsstark(at)mit(dot)edu>:
> On Wed, May 4, 2011 at 3:10 PM, Mitsuru IWASAKI <iwasaki(at)jp(dot)freebsd(dot)org> wrote:
>> Postgres usually starts with ZERO buffer cache.  By saving the buffer
>> cache data structure into hibernation files just before shutdown, and
>> loading them at startup, postgres can start operations with the saved
>> buffer cache as the same condition as just before the last shutdown.
>
> Offhand this seems pretty handy for benchmarks where it would help get
> reproducible results.

It could have an option to force it or not at start of postgres. This
could helps on benchmarks scenarios.

--
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-05-04 16:11:16 Re: Pull up aggregate subquery
Previous Message Jeff Janes 2011-05-04 16:02:01 Re: "full_page_writes" makes no difference?