Re: O_DIRECT option used?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Ruslan A Dautkhanov <rusland(at)scn(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: O_DIRECT option used?
Date: 2002-12-09 21:34:46
Message-ID: 200212092134.gB9LYkY16146@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Read the developer's FAQ on advanced features. We don't think it will
be a big win.

---------------------------------------------------------------------------

Ruslan A Dautkhanov wrote:
> Hello,
>
> In the FreeBSD 4.5 appear additional O_DIRECT option for open(2),
> which mean "eliminate or reduce cache effects". I think, that double
> buffering the same disk blocks is ineffective. I grepped all
> PostgreSQL sources for this options and didn't find this anywhere.
> PgSQL have it's own disk caches, which should be smart
> (DB can know what data should be cached first better than OS).
> Why wasting OS memory for double caches? OS can use this caches
> for other disk blocks, so total cached disk blocks in whole
> system will be much bigger. If you have no plans to implement this,
> please let us know what source files I should looking for patching.
> I think it's somewhere DB tables files are opened (and maybe
> WAL files too). Thanks a lot on any comments.
>
>
>
> ---
> best regards,
> Ruslan A Dautkhanov rusland(at)scn(dot)ru

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2002-12-10 01:08:49 Re: PostgreSQL 7.3 Installation on SCO
Previous Message Jean-Luc Lachance 2002-12-09 20:30:11 Re: [BUGS] 7.3 RMPS bugs ( pgdb.py and postgresql launch script