Re: ext3
От | PFC |
---|---|
Тема | Re: ext3 |
Дата | |
Msg-id | opskrl7arwth1vuj@musicbox обсуждение исходный текст |
Ответ на | ext3 (Mage <mage@mage.hu>) |
Список | pgsql-general |
> 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).
В списке pgsql-general по дате отправления: