Questions tagged [unlogged-tables]
4 questions
6
votes
2 answers
Disadvantages of unlogged tables
To make updates faster, I am using:
ALTER TABLE imagingresourceplanning.opnav_fact_revenue_costs SET UNLOGGED ;
What are the drawbacks of this command?
What will happen if system crashes during the update? Is all the data present in the table…
user2274074
- 351
- 2
- 6
- 12
5
votes
2 answers
Set PostgreSQL table to LOGGED after data loading
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…
Michael
- 243
- 1
- 4
- 15
2
votes
2 answers
Unable to alter partition table to set logged
I have a partition table that I created UNLOGGED. I'm using pg_partman to manage the partition. I then proceeded to load data into it with a COPY command.
Afterwards, I ran an alter table set logged on the parent table but the table still shows as…
efrain berdecia
- 21
- 3
0
votes
2 answers
Empty table after pg_restore
I have a backup of an unlogged table called potential_users, the relation has 58677237 records in it.
Steps:
pg_dump --format custom --verbose --file "potential_users.backup" --table "public.potential_users" productiondb
pg_restore -a -t…
Imanol Y.
- 767
- 1
- 6
- 26