Re: Direct I/O

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: lai yoke hman <lllhman(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Direct I/O
Date: 2007-07-06 14:40:35
Message-ID: 20070706144035.GF5797@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

lai yoke hman wrote:

> How can I know my PostgreSQL 8 is using direct I/O or buffered I/O? If
> using buffered I/O, how can I enable direct I/O? What is the
> performance difference of them?

1. it is buffered
2. you can't
3. there isn't any because there isn't direct I/O

Unless you mess with the filesystem features, at which point I shut up
or they shut me down.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

  • Direct I/O at 2007-07-06 02:28:49 from lai yoke hman

Browse pgsql-performance by date

  From Date Subject
Next Message Arnau 2007-07-06 14:42:31 Advice about how to delete
Previous Message Kalle Hallivuori 2007-07-06 11:30:30 Re: improvement suggestions for performance design