RE: Implement UNLOGGED clause for COPY FROM

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: Implement UNLOGGED clause for COPY FROM
Дата
Msg-id TYAPR01MB299061BCD4659113A19A9300FE240@TYAPR01MB2990.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Implement UNLOGGED clause for COPY FROM  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
> If we can skip the table-copy when ALTER TABLE SET LOGGED on
> wal_level=minimal, is your objective achived?

I expect so, if we can skip the table copy during ALTER TABLE SET LOGGED/UNLOGGED.  On the other hand, both approaches
havedifferent pros and cons.  It's nice that ALTER TABLE doesn't require database restart, but the user has to specify
tables. wal_level = none is vice versa.  Anyway, wal_level = none would be useful for initial data loading after
creatinga new database cluster, as MySQL suggests. 


Regards
Takayuki Tsunakawa





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

Предыдущее
От: "tsunakawa.takay@fujitsu.com"
Дата:
Сообщение: RE: Transactions involving multiple postgres foreign servers, take 2
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: WIP: BRIN multi-range indexes