Set PostgreSQL table to LOGGED after data loading

8 votes

2 answers

8710 views

postgresql postgresql-9.6 unlogged-tables

                          I have created an empty UNLOGGED table to faster copy a large amount of data (over 1 Billion rows). Loading the data took around 4 hours.

Now I want to set the table to LOGGED to make it safe for unexpected shutdowns and crashes. This process takes a long time. In fact it takes longer than loading the data. Is this normal, or is there a way to speed it up?

Asked by Michael (295 rep)

Jan 19, 2018, 11:39 AM
Last activity: Jan 20, 2018, 09:18 PM

Set PostgreSQL table to LOGGED after data loading

Related Questions