Re: Data directory on read-only media - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Data directory on read-only media
Date
Msg-id 20106.1132520018@sss.pgh.pa.us
Whole thread Raw
In response to Data directory on read-only media  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: Data directory on read-only media  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: Plan chosen for PQexecParams
Next
From: "Magnus Hagander"
Date:
Subject: Re: Returning multiple result sets