Questions tagged [unlogged-tables]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer

is it safe to have an unlogged table on the ram disk?

I need to create a table for caching in the postgresql database. Transactions should be as fast as possible, so i thought of creating unlogged table and have a RAM disk as it's tablespace. There is a ...
Tamer Mukayev's user avatar
1 vote
1 answer

Is a Postgresql UNLOGGED table completely lost on process crash?

I use UNLOGGED tables for a few very large tables in a data warehouse style application. Until recently, I understood UNLOGGED to mean “won’t write to the WAL” - which in turn means that recent ...
adam's user avatar
  • 155
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 ...
efrain berdecia's user avatar
1 vote
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....
Imanol Y.'s user avatar
  • 785
6 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 ...
Michael's user avatar
  • 275
8 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 ...
user2274074's user avatar