Allow ALTER TABLE to modify the skip_wal option dynamically
#7,544 opened on Jan 8, 2026
Repository metrics
- Stars
- (6,332 stars)
- PR merge metrics
- (PR metrics pending)
Description
What problem does the new feature solve?
Currently, we use the skip_wal option to control whether WAL is enabled (true means WAL is disabled). However, this option can only be specified when creating a table, e.g. CREATE TABLE ... WITH ('skip_wal'='true');.
We’d like to allow users to modify this option dynamically—setting it to true or false via ALTER TABLE SET <option> = <value>—so they can toggle WAL on or off at runtime.
What does the feature do?
Allow users to modify skip_wal table option dynamically
Implementation challenges
Disabling WAL likely doesn’t require special handling, but enabling it may involve WAL-related resource allocation.
@v0y4g3r may be able to provide more context about this feature.