Re: ext3

On Mon, 17 Jan 2005 20:00:46 +0100, Mage <mage(at)mage(dot)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(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org