Keeping separate WAL segments for each database

Поиск
Список
Период
Сортировка
От Devrim GÜNDÜZ
Тема Keeping separate WAL segments for each database
Дата
Msg-id 1277924046.2965.60.camel@hp-laptop2.gunduz.org
обсуждение исходный текст
Ответы Re: Keeping separate WAL segments for each database  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
I talked to Sybase people about their latest technologies. Many features
that shipped with their latest ASE 15.5 product has been in PostgreSQL
since many years (like functional indexes, etc). :)

One of the things that interested me was parallel recovery feature. They
said that they are keeping separate xlogs for each database, which
speeds ups recovery in case of a crash. It also would increase
performance, since we could write xlogs to separate disks.

Is that doable for PostgreSQL, too?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Admission Control
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Keepalive for max_standby_delay