filesystem options for WAL

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема filesystem options for WAL
Дата
Msg-id 3073cc9b0807052204j14efa56ft113b50013cacddcf@mail.gmail.com
обсуждение исходный текст
Ответы Re: filesystem options for WAL
Список pgsql-performance
Hi,

Here http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm I read:
"""
Combining these two, an optimal fstab for the WAL might look like this:

/dev/hda2  /var ext3 defaults,writeback,noatime 1 2
"""
Is this info accurate?

I also read on other document from the "technical documentation" that
for partitions where you have the tables and indexes is better to have
journaling and for partitions for the WAL is better to not have
journalling...

i tought it has to be the other way (tables & indices without
journalling, WAL with journalling)

--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157

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

Предыдущее
От: "Sergio Gabriel Rodriguez"
Дата:
Сообщение: Re: Subquery WHERE IN or WHERE EXISTS faster?
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: How much work_mem to configure...