From: Dawid Kuroczko <qnex42@gmail.com>
To: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Is AIX Concurrent IO safe with PostgreSQL?
Date: Mon, 25 Jun 2007 12:01:44 +0200
Message-ID: <758d5e7f0706250301s65a39f29ya960ddb3ab5fa692@mail.gmail.com> (raw)
Hello, I am wondering if it is safe to assume that
specifying cio mount option is safe with PostgreSQL.
As far as I understand the CIO (AIX Concurrent I/O) means that
filesystem does not serialize access to file blocks. In other
words multiple threads can simultaneously read and write
the file block, which means that it is possible that reader
reads stale data. Now, if database enforces its own serialization
(and as far as I can tell, bufmgr does it exactly), this option
should be totally safe to use, probably giving boost since
kernel has less overhead while multiple processes access
the database file.
Is my thinking correct?
Regards,
Dawid
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: qnex42@gmail.com
Subject: Re: Is AIX Concurrent IO safe with PostgreSQL?
In-Reply-To: <758d5e7f0706250301s65a39f29ya960ddb3ab5fa692@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox