Curt Sampson <cjs@cynic.net> writes:
> But regardless, perhaps we can add some stuff to the various OSes'
> startup scripts that could help with this. For example, in NetBSD you
> can "dkctl <device> setcache r" for most any disk device (certainly all
> SCSI and ATA) to enable the read cache and disable the write cache.
[ shudder ] I can see the complaints now: "Merely starting up Postgres
cut my overall system performance by a factor of 10! I wasn't even
using it!! What a piece of junk!!!" I can hardly think of a better
way to drive away people with a marginal interest in the database...
This can *not* be default behavior, and unfortunately that limits its
value quite a lot.
regards, tom lane