Revision 13060
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 3496 | 3496 |
LANGUAGE plpgsql |
| 3497 | 3497 |
SET enable_seqscan TO 'off' |
| 3498 | 3498 |
SET search_path TO pg_temp |
| 3499 |
SET join_collapse_limit TO '1' |
|
| 3499 | 3500 |
AS $$ |
| 3500 | 3501 |
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime |
| 3501 | 3502 |
changes of search_path (schema elements are bound at inline time rather than |
Also available in: Unified diff
fix: schemas/vegbien.sql: public_validations.rematerialize_out_view(text, regclass): run with join_collapse_limit = 1 to fix query planner issues. this option has been tested on the queries that do not yet use the standard join sequence (plots #11,12,13,14,16,17,18), and all of these queries also work fine with join_collapse_limit = 1. (the standard join sequence is used to ensure both correctness of the query and compatibility with join_collapse_limit = 1, but in some cases is not needed for join_collapse_limit.)