Thread: pgsql: Document that non-data journaling is a recommended mount option.
pgsql: Document that non-data journaling is a recommended mount option.
From
momjian@postgresql.org (Bruce Momjian)
Date:
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)
Re: pgsql: Document that non-data journaling is a recommended mount option.
From
"Jaime Casanova"
Date:
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
Re: pgsql: Document that non-data journaling is a recommended mount option.
From
Bruce Momjian
Date:
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. +