Heikki Linnakangas <hlinnaka(at)iki(dot)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