Feature Suggestion: Make synchronous_commit a table level property - Mailing list pgsql-hackers

From Anas-ur-Rasheed Khan
Subject Feature Suggestion: Make synchronous_commit a table level property
Date
Msg-id CAAZq3JHfkkphQw7-T0_H-m=TZWUkaQ-YkJ=53NbKFTW6TVF9cA@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Hi hackers,


We have a use case where some tables are derived, i.e., can be reconstructed entirely from 'source' tables (similar to views, but more complex mathematical transformations are applied). Data integrity and durability are important for 'source' tables, but not so much for derived tables. In the event of a crash, it is important that we can recover data from volatile memory for 'source' tables.

What are your thoughts on this, and potentially adding such support in future postgres versions?


Thanks,
AK

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: vacuum_multixact_failsafe_age doesn't account for MultiXact member exhaustion
Next
From: Jeff Davis
Date:
Subject: Re: Statistics Import and Export