Mercurial > gemma

annotate schema/updates/1004/01.optimize_index-setup.sql @ 5736:55892008ec96 default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed a bunch of corner cases in WG import.
author Sascha Wilde <wilde@sha-bang.de>
date Wed, 29 May 2024 19:02:42 +0200
parents 9ab7e1056360
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4016
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 ALTER TABLE waterway.gauge_measurements
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 DROP CONSTRAINT gauge_measurements_location_measure_date_staging_done_key;
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 ALTER TABLE waterway.gauge_measurements
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 ADD CONSTRAINT gauge_measurements_measure_date_location_staging_done_key
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5 UNIQUE (measure_date, location, staging_done);
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6 DROP INDEX waterway.gauge_measurements_measure_date;
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
8 ALTER TABLE waterway.gauge_predictions
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
9 DROP CONSTRAINT gauge_predictions_pkey;
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
10 ALTER TABLE waterway.gauge_predictions
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
11 ADD CONSTRAINT gauge_predictions_pkey
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
12 PRIMARY KEY (measure_date, location, date_issue);
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
13 DROP INDEX waterway.gauge_predictions_measure_date;
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
14
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
15 CREATE INDEX gauge_measurements_location_measure_date_desc
9ab7e1056360 Optimize index setup a bit
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
16 ON waterway.gauge_measurements (location, measure_date DESC)