Revision 12625
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 3139 | 3139 |
|
| 3140 | 3140 |
CREATE FUNCTION rematerialize_out_view(datasource_schema text, out_view regclass) RETURNS regclass |
| 3141 | 3141 |
LANGUAGE plpgsql |
| 3142 |
SET enable_seqscan TO 'off' |
|
| 3142 | 3143 |
SET search_path TO pg_temp |
| 3143 | 3144 |
AS $$ |
| 3144 | 3145 |
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: rematerialize_out_view(): run all queries with `SET enable_seqscan = off` to avoid slow query plans. this fixes _plots_06_list_of_plots_with_stem_measurements and significantly speeds up _plots_10_count_of_individuals_per_plot_in_each_project (and possibly others).