Raw devices (was Re: Berkeley DB license)
alex@pilosoft.com
From: Alex Pilosov <alex@pilosoft.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Date: 2000-05-20T04:31:02Z
Lists: pgsql-hackers
On Sat, 20 May 2000, Bruce Momjian wrote: > And there is the problem of cache wiping, where a large sequential scan > removes all other cached blocks from the buffer. I don't know a way to > prevent that one, though we could have large sequential scans reuse > their own buffer, rather than grabbing the oldest buffer. On some systems, you can specify (or hint) to the kernel that the file you are reading should not be buffered. The only (completely) real solution for this is to use raw devices, uncached by the kernel, without any filesystem overhead... Are there any plans to support that?