Questions tagged [unlogged-tables]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
24 views

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 ...
1
vote
2answers
341 views

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....
1
vote
2answers
846 views

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 ...
1
vote
2answers
1k views

Postgresql: what are the disadvantages of unlogged table

To make update faster i am using below command. ALTER TABLE imagingresourceplanning.opnav_fact_revenue_costs SET UNLOGGED ; I want to know what are the drawbacks of this command.