Re: Data directory on read-only media

Heikki Linnakangas <hlinnaka@iki.fi> writes:
> 5. Don't try to write buffers with commit hint modifications. Just discard 
> them.

The performance costs of that alone are astonishing (ie, repeated
verifications of commit status).

I think what you are doing is a completely wrongheaded way to approach
it... it sounds incredibly invasive, messy, and fragile.  A database or
tablespace that has been frozen (per VACUUM FREEZE) could sensibly be
put on read-only media, but I can't see doing the rest of this.  Have
you thought about putting the more dynamic stuff onto a RAM disk?
        regards, tom lane