Re: a provocative question?

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: a provocative question?
Date: 2007-09-07 05:07:03
Message-ID: 46E0DC77.20801@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/06/07 20:45, Chris Browne wrote:
> quension(at)gmail(dot)com ("Trevor Talbot") writes:
>> There's also a point in regard to how modifications are made to your
>> data store. In general, things working with text files don't go to
>> much effort to maintain durability like a real database would. The
>> most direct way of editing a text file is to make all the changes in
>> memory, then write the whole thing out. Some editors make backup
>> files, or use a create-delete-rename cycle, but they won't
>> necessarily force the data to disk -- if it's entirely in cache you
>> could end up losing the contents of the file anyway.
>
> In the case of Eudora, if its filesystem access protocol involves
> writing a new text file, and completing that before unlinking the old
> version, then the risk of "utter destruction" remains fairly low
> specifically because of the nature of access protocol.

mbox is a monolithic file also, and you need to copy/delete,
copy/delete, yadda yadda yadda. Just to do anything, you need 2x as
much free disk space as you biggest mbox file. What a PITA.

mh and Maildir are, as has been partially mentioned, much more
efficient in that regard.

(Yes... mbox is an excellent transport format.)

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG4Nx3S9HxQb37XmcRAg+6AJ42gRm82MTmocxNC2hp3yQ9ZsFhQgCgoXVQ
i51vvPBwN2Qot2TUR9AjMBY=
=8WKX
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-09-07 05:17:01 Re: dblink vs dbi-link (and errors compiling)
Previous Message Joshua D. Drake 2007-09-07 04:01:14 Re: Call for Speakers PostgreSQL Conference Fall 2007