From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Magicloud Wang <magicloud(at)pogolinux(dot)com(dot)cn> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Would it be OK if I put db file on a ext2 filesystem? |
Date: | 2007-12-12 16:13:08 |
Message-ID: | 20071212161308.GG7925@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-12-12 16:17:24 | Re: Would it be OK if I put db file on a ext2 filesystem? |
Previous Message | Pavel Stehule | 2007-12-12 16:13:01 | Re: convert function |