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

From tsunakawa.takay@fujitsu.com
Subject RE: Disable WAL logging to speed up data loading
Date
Msg-id TYAPR01MB2990ECE456477C5613F84D4CFED50@TYAPR01MB2990.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Disable WAL logging to speed up data loading  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
From: Michael Paquier <michael@paquier.xyz>
> Something that has not been mentioned on this thread is that if you could also
> put pg_wal/ on a RAM disk.  That's similarly unsafe, of course, but it does not
> require any extra upstream patching, and that should be really fast for the case
> of this thread.  If you care about consistency, there are solutions like PMEM
> that we could look more into.

As noted in this thread, the customer is worried about and wants to avoid handling the possible high volume storage of
WALduring the data loading.  That's understandable.  In that regard, DRAM and PMEM are worse because their capacity is
morelimited than SSD. 


Regards
Takayuki Tsunakawa





pgsql-hackers by date:

Previous
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: Global snapshots
Next
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: Disable WAL logging to speed up data loading