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.

Sign up for GitHub

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

Jump to bottom

Decide whether to auto-enable --tables-only for large collections #207

Open
jpmckinney opened this issue Jul 20, 2021 · 0 comments
Open

Decide whether to auto-enable --tables-only for large collections #207

jpmckinney opened this issue Jul 20, 2021 · 0 comments
Labels
cli Relating to the command-line interface

Comments

@jpmckinney
Copy link
Member

The performance of persistent tables (and materialized views) is better than views, especially when the views' underlying query is complex. The downside is that tables use more disk space.

In practice, I don't know what the threshold is, past which the performance is so degraded that it is worth using the extra disk space. I'll just log the issue for now.
@jpmckinney jpmckinney added the cli Relating to the command-line interface label Jul 20, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
cli Relating to the command-line interface
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jpmckinney