Magicloud Wang wrote: > Dear, > I think database has its own operation journal, and different journal > filesystem does give different performance. So if I put database file on a > non-journal filesystem, would it be safe? Does this like using a raw device? Regular database files need metadata journalling (data=writeback mount option for ext3). This is quite faster than full-blown journalling which is what you get with default ext3 mount options. WAL files (pg_xlog) do not need any kind of journalling, so you can save the overhead and put them on an ext2 filesystem (or any other nonjournalled filesystem). -- Alvaro Herrera Developer, http://www.PostgreSQL.org/ Voy a acabar con todos los humanos / con los humanos yo acabaré voy a acabar con todos / con todos los humanos acabaré (Bender) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
