Dawid Kuroczko wrote:
The ext3fs allows to selet type of journalling to be used with
filesystem. Journalling pretty much mirrors the work of WAL
logging by PostgreSQL... I wonder which type of journalling
is best for PgSQL in terms of performance.
Choices include:
journal
Am I right to assume that writeback is both fastest and at
the same time as safe to use as ordered? Maybe any of you
did some benchmarks?
It should be fastest because it is the least overhead, and safe because
postgres does it's own write-order guaranteeing through fsync(). You should
also
I have some data here, no detailed analyses though:
http://www.osdl.org/projects/dbt2dev/results/fs/
Mark
On Mon, Nov 08, 2004 at 01:26:09PM +0100, Dawid Kuroczko wrote:
The ext3fs allows to selet type of journalling to be used with
filesystem. Journalling pretty much mirrors the
Matt,
It should be fastest because it is the least overhead, and safe because
postgres does it's own write-order guaranteeing through fsync(). You
should also mount the FS with the 'noatime' option.
This, of course, assumes that PostgreSQL is the only thing on the partition.
Which is a