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).
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
