Re: Win32 Powerfail testing - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Win32 Powerfail testing
Date
Msg-id 200303072101.h27L1Jc24842@candle.pha.pa.us
Whole thread Raw
In response to Re: Win32 Powerfail testing  (Kevin Brown <kevin@sysexperts.com>)
Responses Re: Win32 Powerfail testing
List pgsql-hackers
Kevin Brown wrote:
> Bruce Momjian wrote:
> > The idea of using this on Unix is tempting, but Tatsuo is using a
> > threaded backend, so it is a little easier to do.  However, it would
> > probably be pretty easy to write a file of modified file names that the
> > checkpoint could read and open/fsync/close.
> 
> Even that's not strictly necessary -- we *do* have shared memory we
> can use for this, and even when hundreds of tables have been written
> the list will only end up being a few tens of kilobytes in size (plus
> whatever overhead is required to track and manipulate the entries).
> 
> But even then, we don't actually have to track the *names* of the
> files that have changed, just their RelFileNodes, since there's a
> mapping function from the RelFileNode to the filename.

But we have to allow an unlimited number of files.  Perhaps we could
just fall back to sync if the shared memory overflows, and shared memory
is finite.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: regression failure in CVS HEAD
Next
From: Doug McNaught
Date:
Subject: Re: regression failure in CVS HEAD