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
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 |