RE: Implement UNLOGGED clause for COPY FROM - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: Implement UNLOGGED clause for COPY FROM
Date
Msg-id TYAPR01MB299061BCD4659113A19A9300FE240@TYAPR01MB2990.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Implement UNLOGGED clause for COPY FROM  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List 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 by date:

Previous
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: Transactions involving multiple postgres foreign servers, take 2
Next
From: Tomas Vondra
Date:
Subject: Re: WIP: BRIN multi-range indexes