On Mon, 17 Jan 2005 20:00:46 +0100, Mage <mage@xxxxxxx> 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@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
