RE: Disable WAL logging to speed up data loading

Поиск
Список
Период
Сортировка
От osumi.takamichi@fujitsu.com
Тема RE: Disable WAL logging to speed up data loading
Дата
Msg-id OSBPR01MB4888CFB6A9E6463F81AF2837ED330@OSBPR01MB4888.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Disable WAL logging to speed up data loading  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Ответы Re: Disable WAL logging to speed up data loading
Список pgsql-hackers
Hello, Ashutosh

> Can they use a database with all unlogged tables?
Unfortunately, no. They want to switch a cluster condition to "without WAL logging"
only when they execute night bulk loading for their data warehouse.
In other words, they would like to keep their other usual operations with WAL.
In addition, using all tables as unlogged brings about
the risk to lose data warehouse's data caused by an unexpected server crash or power outage.

Regards,
    Takamichi Osumi

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Use PG_FINALLY to simplify code
Следующее
От: Amit Langote
Дата:
Сообщение: Re: problem with RETURNING and update row movement