Postgres Pro
Downloads
Home   >   mailing lists

Re: Would it be OK if I put db file on a ext2 filesystem? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Would it be OK if I put db file on a ext2 filesystem?
Date
Msg-id 20071212161308.GG7925@alvh.no-ip.org
Whole thread Raw
In response to Would it be OK if I put db file on a ext2 filesystem?  (Magicloud Wang <magicloud@pogolinux.com.cn>)
Responses Re: Would it be OK if I put db file on a ext2 filesystem?
List pgsql-general
Tree view 
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)

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: convert function
Next
From: "Scott Marlowe"
Date:
Subject: Re: Would it be OK if I put db file on a ext2 filesystem?