Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Koichi SuzukiDate: 2007-06-25 10:06:07
Subject: Re: PITR Backups
Previous:From: Mikko PartioDate: 2007-06-25 07:50:48
Subject: Re: Slow indexscan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group