From: Alvaro Herrera <alvherre@commandprompt.com>
To: lai yoke hman <lllhman@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Direct I/O
Date: Fri, 6 Jul 2007 10:40:35 -0400
Message-ID: <20070706144035.GF5797@alvh.no-ip.org> (raw)
In-Reply-To: <BAY126-W47B86724087E7C49F49E74A9010@phx.gbl>
References: <BAY126-W47B86724087E7C49F49E74A9010@phx.gbl>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, lllhman@hotmail.com
Subject: Re: Direct I/O
In-Reply-To: <20070706144035.GF5797@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox