Skip to content
Snippets Groups Projects

join_collapse_limit and from_collapse_limit options applied at the end of...

Merged Bartek Wrona requested to merge apply_sql_planner_options into develop
1 file
+ 10
0
Compare changes
  • Side-by-side
  • Inline
+ 10
0
@@ -1016,6 +1016,16 @@ def setup(db):
@@ -1016,6 +1016,16 @@ def setup(db):
"""
"""
db.query_no_return(sql)
db.query_no_return(sql)
 
sql = """
 
DO $$
 
BEGIN
 
EXECUTE 'ALTER DATABASE '||current_database()||' SET join_collapse_limit TO 16';
 
EXECUTE 'ALTER DATABASE '||current_database()||' SET from_collapse_limit TO 16';
 
END
 
$$;
 
"""
 
db.query_no_return(sql)
 
def reset_autovac(db):
def reset_autovac(db):
"""Initializes/resets per-table autovacuum/autoanalyze params.
"""Initializes/resets per-table autovacuum/autoanalyze params.
Loading