Is AIX Concurrent IO safe with PostgreSQL?

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Is AIX Concurrent IO safe with PostgreSQL?
Date: 2007-06-25 10:01:44
Message-ID: 758d5e7f0706250301s65a39f29ya960ddb3ab5fa692@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Browse pgsql-performance by date

  From Date Subject
Next Message Koichi Suzuki 2007-06-25 10:06:07 Re: PITR Backups
Previous Message Mikko Partio 2007-06-25 07:50:48 Re: Slow indexscan