Re: [PATCHES] Cleaning up unreferenced table files - Mailing list pgsql-hackers

From Greg Stark
Subject Re: [PATCHES] Cleaning up unreferenced table files
Date
Msg-id 877ji9t6a5.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: [PATCHES] Cleaning up unreferenced table files  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCHES] Cleaning up unreferenced table files  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Heikki Linnakangas <hlinnaka@iki.fi> writes:
> > Consider the variant with extra marker files. In that case, backend B 
> > doesn't have to know about the .notcommitted status to flush the buffers.
> 
> [ shrug ]  It's still broken, and the reason is that there's no
> equivalent of fsync for directory operations.  Consider

Traditionally that's because directory operations were always synchronous, and
hence didn't need to be fsynced. I think this is still true, other systems
like qmail's maildir still depend on this, for example.

-- 
greg



pgsql-hackers by date:

Previous
From: Bob
Date:
Subject: Re: Oracle Style packages on postgres
Next
From: Greg Stark
Date:
Subject: Re: pl/pgsql enabled by default