Re: ext3

On Mon, 17 Jan 2005 20:00:46 +0100, Mage <mage@mage.hu> wrote:
>           Hello,
>
> Gabor Szima asked us to translate the letter below.
>
> "I read that ext3 writeback mode is recommended for PostgreSQL. I made
> some tests.
>
>                 data=ordered        data=writeback
> ----------------------------------------------------------------------
> restoredb:             2m16.790s        1m42.367s
> UPDATE <tbl1> (17krows):    9.289s            7.147s
> UPDATE <tbl1> (17krows) (2.):    10.480s            3.778s
> VACUUM ANALYZE <tbl1>:        9.364s            0.986s !
> VACUUM FULL <tbl1>:        16.071s            2.575s
> REINDEX TABLE <tbl1>:        3.815s            1.886s
> ----------------------------------------------------------------------
>
> It's seductive.
> However I made some crash-tests too. Updated 4 tables simultaneously and
> recurring for 10 to 120s, then powered off the machine (without the
> reset button. i just pulled out the cable).

That's an excellent way to fry your PSU and damage your hardware.


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org