I did not completely understand you.
Postgresql only uses regular files as its db. Do you suggest something
like mounting
an image file that supports RW? can you give an example?
I suspect an image file on top of a filesystem won't help here since
"the disk" to this image is actually the filesystem, so I wouldn't expect
real flushing of buffers to the disk to occure on unmount.
But I'm just guessing. If someone know better then I'd be glad to be
corrected.
If you mean native partitions then postgresql does not support these.
I don't mind low performance since its all relative to other runs in the
benchmarking.
You might be correct up to a point - low(er) I/O throughput over the entire
set of benchmarks might overshadow processor performance problems, or
just generally skew the relations between the results.
Sadly postgresql relies on the underlying OS caching. Readaheads and
all,
they have O_DIRECT on their todo list...
so its currently not possible.
Regards,
tzahi.
BTW - try not to top-post (i.e. stick your reply on top of the entire quoted text
you are replying to). I used to do this myself recently until I've seen the light
(and a few comments from people in various forums about this).
--Amos
