On 2020/09/30 12:10, osumi.takami...@fujitsu.com wrote:
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.
But the same issue can happen even in the proposed approach
because Tsunakawa-san explains as follows?
The server refuses to start (pg_ctl start fails) after an abnormal shutdown due
to power outage, pg_ctl's immediate shutdown, etc, showing a straightforward
message like MySQL.
Regards,
--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION
