From: | Ruslan A Dautkhanov <rusland(at)scn(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | O_DIRECT option used? |
Date: | 2002-12-08 14:52:40 |
Message-ID: | 3DF35CB8.E87E3EBE@scn.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2002-12-08 16:45:36 | 7.3 RMPS bugs ( pgdb.py and postgresql launch script ) |
Previous Message | Ruslan A Dautkhanov | 2002-12-08 13:28:45 | datatypes: text vs varchar |