Questions tagged [unlogged-tables]
The unlogged-tables tag has no usage guidance.
6
questions
0
votes
1
answer
34
views
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 ...
1
vote
1
answer
201
views
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 ...
- 155
2
votes
2
answers
1k
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
2
answers
2k
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....
- 785
6
votes
2
answers
6k
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 ...
- 275
8
votes
2
answers
6k
views
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 ...
- 411