Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feature request: default visibility_mode as a system parameter #15322

Closed
fuyufjh opened this issue Feb 28, 2024 · 3 comments
Closed

feature request: default visibility_mode as a system parameter #15322

fuyufjh opened this issue Feb 28, 2024 · 3 comments

Comments

@fuyufjh
Copy link
Member

fuyufjh commented Feb 28, 2024

Is your feature request related to a problem? Please describe.

https://risingwave-community.slack.com/archives/C05U5NV4LHY/p1709036227434699

Hi again, is it possible to set the visibility_mode runtime parameter to be “all” by default for all client sessions? In many of our use-cases we will have clients querying the latest real-time data from RisingWave MV’s and thus would need to set the visibility_mode to “all” to achieve this currently on each connection.

Describe the solution you'd like

Provide a system parameter visibility_mode, which can override the default value of session variable visible

Describe alternatives you've considered

The requirements also apply to many other session variables, such as isolation_level, query_mode, etc. Is it possible to build a common framework?

preset default value <-- system parameter <-- session variable
// Arrows mean overriding if set.

Additional context

No response

@github-actions github-actions bot added this to the release-1.7 milestone Feb 28, 2024
@xiangjinwu
Copy link
Contributor

related: #8851 #13554

@yuhao-su yuhao-su self-assigned this Feb 28, 2024
@BugenZhao
Copy link
Member

The requirements also apply to many other session variables, such as isolation_level, query_mode, etc. Is it possible to build a common framework?

This sounds like similar to the configuration framework in Postgres, which supports setting variables in different levels: https://www.postgresql.org/docs/current/config-setting.html#CONFIG-SETTING-SQL

The context column in pg_settings table also reflect that: https://www.postgresql.org/docs/current/view-pg-settings.html#VIEW-PG-SETTINGS

@yuhao-su yuhao-su modified the milestones: release-1.7, release-1.8 Mar 6, 2024
Copy link
Contributor

github-actions bot commented May 7, 2024

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants