RE: Disable WAL logging to speed up data loading - Mailing list pgsql-hackers

From osumi.takamichi@fujitsu.com
Subject RE: Disable WAL logging to speed up data loading
Date
Msg-id OSBPR01MB4888CFB6A9E6463F81AF2837ED330@OSBPR01MB4888.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Disable WAL logging to speed up data loading  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Responses Re: Disable WAL logging to speed up data loading  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Use PG_FINALLY to simplify code
Next
From: Amit Langote
Date:
Subject: Re: problem with RETURNING and update row movement