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 g
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
> 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
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:
> jour
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
All data
