pgsql: Document that non-data journaling is a recommended mount option.

Started by Bruce Momjianover 17 years ago3 messagescomitters
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Log Message:
-----------
Document that non-data journaling is a recommended mount option.

Modified Files:
--------------
pgsql/doc/src/sgml:
wal.sgml (r1.53 -> r1.54)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/wal.sgml?r1=1.53&r2=1.54)

#2Jaime Casanova
jcasanov@systemguards.com.ec
In reply to: Bruce Momjian (#1)
Re: pgsql: Document that non-data journaling is a recommended mount option.

On Sat, Dec 6, 2008 at 4:34 PM, Bruce Momjian <momjian@postgresql.org> wrote:

Log Message:
-----------
Document that non-data journaling is a recommended mount option.

i'm always confused about this... you mean turn off data journaling in
the disks that stores the datafiles, right? not in the disks where the
WAL in...

can be more explicit about one or the other?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

#3Bruce Momjian
bruce@momjian.us
In reply to: Jaime Casanova (#2)
Re: pgsql: Document that non-data journaling is a recommended mount option.

Jaime Casanova wrote:

On Sat, Dec 6, 2008 at 4:34 PM, Bruce Momjian <momjian@postgresql.org> wrote:

Log Message:
-----------
Document that non-data journaling is a recommended mount option.

i'm always confused about this... you mean turn off data journaling in
the disks that stores the datafiles, right? not in the disks where the
WAL in...

can be more explicit about one or the other?

You can turn off data journally for WAL and non-WAL disks because we
call fsync() when we need data flushed to disk. The problem is that by
default ext3 flushes data to disk for table files during journaling
operation.

What additional text needs to be added?

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +