Greg: Thank you very much for your insightful comments on the performance of
direct io applied to postgres! That inspired me a lot.
Tom: thank you for the reference to man page!
On Fri, Jun 18, 2010 at 2:02 AM, Greg Smith wrote:
> Daniel Ng wrote:
>
>> I am trying to enable the direct IO for t
Daniel Ng wrote:
I am trying to enable the direct IO for the disk-resident
hash partitions of hashjoin in postgresql.
As Tom already mentioned this isn't working because of alignment
issues. I'm not sure what you expect to achieve though. You should be
warned that other than the WAL, every
Daniel Ng writes:
>I am trying to enable the direct IO for the disk-resident
> hash partitions of hashjoin in postgresql.
Why would you think that's a good idea?
> Can anyone advise what's the reason and how to fix this?
Per the open(2) man page:
The O_DIRECT flag may impose ali
Dear all,
I am trying to enable the direct IO for the disk-resident
hash partitions of hashjoin in postgresql. The basic postgres
environment settings are:
centos 5.5
kernel 2.6.18
ext3 fs
PostgreSQL 8.4.3
Previously I added the O_DIRECT flag to the "fileF