Shouldn't flush dirty buffers at shutdown ? - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Shouldn't flush dirty buffers at shutdown ?
Date
Msg-id NDBBIJLOILGIKBGDINDFMEOCCEAA.Inoue@tpf.co.jp
Whole thread Raw
Responses Re: Shouldn't flush dirty buffers at shutdown ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@tpf.co.jp


pgsql-hackers by date:

Previous
From: "Cary O'Brien"
Date:
Subject: Commercializing PostgreSQL: What do you thing?
Next
From: Tom Lane
Date:
Subject: Re: Shouldn't flush dirty buffers at shutdown ?