Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE INDEX perception_run_frame_idx_run_266_thru_270
- ON run.perception
- (run_id, frame)
- WHERE run_id >= 266 AND run_id <= 270;
- CREATE TABLE run.perception(
- id bigint NOT NULL,
- run_id bigint NOT NULL,
- frame bigint NOT NULL,
- by character varying(45) NOT NULL,
- by_anyone bigint NOT NULL,
- by_me bigint NOT NULL,
- by_s_id integer,
- owning_p_id bigint NOT NULL,
- obj_type_set bigint,
- seq integer,
- subj_id bigint NOT NULL,
- subj_state_frame bigint NOT NULL,
- CONSTRAINT perception_pkey PRIMARY KEY (id))
- CREATE TABLE run.perception(
- id bigint NOT NULL PRIMARY KEY
- , run_id bigint NOT NULL
- , frame bigint NOT NULL
- , by_anyone bigint NOT NULL
- , by_me bigint NOT NULL
- , owning_p_id bigint NOT NULL
- , subj_id bigint NOT NULL
- , subj_state_frame bigint NOT NULL
- , obj_type_set bigint
- , by_s_id integer
- , seq integer
- , by varchar(45) NOT NULL -- or just use type text
- );
- CREATE INDEX perception_run_id266_idx ON run.perception(frame) WHERE run_id = 266;
- CREATE INDEX perception_run_id266_idx ON run.perception(frame) WHERE run_id = 267;
- CREATE INDEX perception_run_id266_idx ON run.perception(frame) WHERE run_id = 268;
- CREATE INDEX perception_run_id266_idx ON run.perception(frame) WHERE run_id = 269;
- CREATE INDEX perception_run_id266_idx ON run.perception(frame) WHERE run_id = 270;
- CREATE INDEX foo ON run.perception USING brin (run_id, frame)
- WHERE run_id >= 266 AND run_id <= 270;
- BEGIN;
- SET LOCAL maintenance_work_mem = 10GB; -- depends on resulting index size
- CREATE INDEX perception_run_frame_idx_run_266_thru_270 ON run.perception(run_id, frame)
- WHERE run_id >= 266 AND run_id <= 270;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement