Re: PostgreSQL and Journaled File Systems

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL and Journaled File Systems
Дата
Msg-id 9182.1060206619@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PostgreSQL and Journaled File Systems  (Roberto Mello <rmello@cc.usu.edu>)
Список pgsql-sql
Roberto Mello <rmello@cc.usu.edu> writes:
> What is the word about using PG with journaled file systems? I have heard
> that it's best to not have the PG journal in a journaled system to avoid
> double journaling.

Journaling metadata is good.  Journaling file contents is redundant ---
turn that off if you can.  (Of course, if there is anything other than
Postgres files on the same device, you may not want to turn off contents
journalling...)
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: Andrew Droffner
Дата:
Сообщение: Re: User-defined SQL function has slower query on 7.3.3 than
Следующее
От: "Maksim Likharev"
Дата:
Сообщение: Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram