Shouldn't flush dirty buffers at shutdown ?

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Shouldn't flush dirty buffers at shutdown ?
Date: 2000-05-09 14:34:17
Message-ID: NDBBIJLOILGIKBGDINDFMEOCCEAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

While testing vacuum,I noticed that dirty buffers aren't
necessarily written to disk in case of abort.
In addtion they have no guarantee to be flushed before
the shutdown of postmaster. The recent bufmgr changes
seems to have increased the possibility much more than
before.
Certainly it's not bad unless there are indexes. However
if heap data wasn't flushed while corresponding indices
are written to disk,the indices would point to non-existence
heap block. It would be the cause of inconsistency after the
restart of postmaster. Shouldn't there be a mechanism to
flush dirty buffers at(or before) the shutdown of postmaster ?

Comments ?

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-05-09 14:49:31 Re: Shouldn't flush dirty buffers at shutdown ?
Previous Message Cary O'Brien 2000-05-09 14:21:43 Commercializing PostgreSQL: What do you thing?