pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDirect I/O
3+ messages / 3 participants
[nested] [flat]
* Direct I/O
@ 2007-07-06 02:28 lai yoke hman <lllhman@hotmail.com>
2007-07-06 14:40 ` Re: Direct I/O Alvaro Herrera <alvherre@commandprompt.com>
2007-07-06 16:03 ` Re: Direct I/O Jignesh K. Shah <J.K.Shah@Sun.COM>
0 siblings, 2 replies; 3+ messages in thread
From: lai yoke hman @ 2007-07-06 02:28 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Direct I/O
2007-07-06 02:28 Direct I/O lai yoke hman <lllhman@hotmail.com>
@ 2007-07-06 14:40 ` Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 0 replies; 3+ messages in thread
From: Alvaro Herrera @ 2007-07-06 14:40 UTC (permalink / raw)
To: lai yoke hman <lllhman@hotmail.com>; +Cc: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Direct I/O
2007-07-06 02:28 Direct I/O lai yoke hman <lllhman@hotmail.com>
@ 2007-07-06 16:03 ` Jignesh K. Shah <J.K.Shah@Sun.COM>
1 sibling, 0 replies; 3+ messages in thread
From: Jignesh K. Shah @ 2007-07-06 16:03 UTC (permalink / raw)
To: lai yoke hman <lllhman@hotmail.com>; +Cc: pgsql-performance
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-07-06 16:03 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-06 02:28 Direct I/O lai yoke hman <lllhman@hotmail.com>
2007-07-06 14:40 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-07-06 16:03 ` Jignesh K. Shah <J.K.Shah@Sun.COM>
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