Heikki Linnakangas <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org