Re: Vacuum, Freeze and Analyze: the big picture

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Vacuum, Freeze and Analyze: the big picture
Дата
Msg-id 1371079876.48038.YahooMailNeo@web162906.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: Vacuum, Freeze and Analyze: the big picture  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Jeff Janes <jeff.janes@gmail.com> wrote:

> Are there other anecdotes about what settings work well in
> practise, assuming people ever find ones that work well?

Putting WAL on its own RAID on its own battery-backed cached can
help a lot more than I would have thought -- even with read-only
transactions.

http://www.postgresql.org/message-id/4B71358E020000250002F0E4@gw.wicourts.gov

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: [9.3] Automatically updatable views vs writable foreign tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [9.3] Automatically updatable views vs writable foreign tables