Re: Direct I/O - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Direct I/O
Date
Msg-id 20070706144035.GF5797@alvh.no-ip.org
Whole thread Raw
In response to Direct I/O  (lai yoke hman <lllhman@hotmail.com>)
List 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.

pgsql-performance by date:

Previous
From: "Kalle Hallivuori"
Date:
Subject: Re: improvement suggestions for performance design
Next
From: Arnau
Date:
Subject: Advice about how to delete