Re: Data directory on read-only media

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Data directory on read-only media
Дата
Msg-id 20106.1132520018@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Data directory on read-only media  (Heikki Linnakangas <hlinnaka@iki.fi>)
Ответы Re: Data directory on read-only media  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Plan chosen for PQexecParams
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Returning multiple result sets