Feature Suggestion: Make synchronous_commit a table level property

From: Anas-ur-Rasheed Khan <annicheez(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Feature Suggestion: Make synchronous_commit a table level property
Date: 2025-05-21 21:05:32
Message-ID: CAAZq3JHfkkphQw7-T0_H-m=TZWUkaQ-YkJ=53NbKFTW6TVF9cA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2025-05-21 21:11:56 Re: strange perf regression with data checksums
Previous Message Peter Geoghegan 2025-05-21 20:46:48 vacuum_multixact_failsafe_age doesn't account for MultiXact member exhaustion