Re: [PATCHES] Cleaning up unreferenced table files

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] Cleaning up unreferenced table files
Date: 2005-05-09 03:41:38
Message-ID: 877ji9t6a5.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Heikki Linnakangas <hlinnaka(at)iki(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Satoshi Nagayasu 2005-05-09 03:48:02 Re: [HACKERS] read-only database
Previous Message Bob 2005-05-09 03:38:41 Re: Oracle Style packages on postgres

Browse pgsql-patches by date

  From Date Subject
Next Message Satoshi Nagayasu 2005-05-09 03:48:02 Re: [HACKERS] read-only database
Previous Message Tom Lane 2005-05-09 02:46:12 Re: Added columns to pg_stat_activity