> 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
> ----------------------------------------------------------------------
Hum. You might as well run it with fsync disabled for that extra thrill ;)
You could try the same with reiserfs (hint, hint).
