From: Jignesh K. Shah <J.K.Shah@Sun.COM>
To: lai yoke hman <lllhman@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Direct I/O
Date: Fri, 06 Jul 2007 12:03:12 -0400
Message-ID: <468E67C0.60405@sun.com> (raw)
In-Reply-To: <BAY126-W47B86724087E7C49F49E74A9010@phx.gbl>
References: <BAY126-W47B86724087E7C49F49E74A9010@phx.gbl>
On Solaris you just look at the mount options on the file system and see
if there is a forcedirectio option enabled. Generally since PostgreSQL
doesn't use any special options for enabling directio that's a known way
to figure it out on Solaris. Atleast on Solaris the performance over
buffered filesystem is better for many workloads but not always. Plus
you typically see a small reduction in CPU usage (system) and ofcourse
memory.
However depending on workload, you may see increased latency in writes
but generally that's not the problem in many workloads since its the
multiple writes to the same file which is better using concurrentio
(modified directio) in Solaris.
As for Linux I will leave that to other experts ..
-Jignesh
lai yoke hman wrote:
> Hello,
> 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?
> This is urgent, Thanks.
> _________________________________________________________________
> Windows Live Spaces is here! It¡¦s easy to create your own personal Web site.
> http://spaces.live.com/?mkt=en-my
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
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: J.K.Shah@Sun.COM, lllhman@hotmail.com
Subject: Re: Direct I/O
In-Reply-To: <468E67C0.60405@sun.com>
* 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