Re: Re: Recovery of PGSQL after system crash failing!!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Recovery of PGSQL after system crash failing!!!
Date: 2001-02-14 04:47:15
Message-ID: 12582.982126035@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
> Also, could the "-F" option be disabled now that WAL is enabled? Or is
> there still some reason to encourage/allow folks to use it?

I was the one who put it back in after Vadim turned it off ;-) ... and
I'll object to any attempt to remove the option.

I think that there's no longer any good reason for people to consider -F
in production use. On the other hand, for development or debugging work
where you don't really *care* about powerfail survivability, I see no
reason to incur extra wear on your disk drives by forcing fsyncs. My
drives only have so many seeks left in 'em, and I'd rather see those
seeks expended on writing source-code files than on fsyncs of test
databases.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-02-14 06:19:33 ODBC <6.4 protocol
Previous Message Bruce Momjian 2001-02-14 02:40:07 Re: Re: Recovery of PGSQL after system crash failing!!!