I have this tables to feed my routing engine using pgr_trsp:
vzla_rto have the links and nodes (650k)
vzla_restriction have the turn restrictions (10k)
CREATE TABLE map.vzla_restrictions( rid integer NOT NULL, to_cost numeric, to_edge integer, from_edge integer, via text);CREATE INDEX vzla_restrictions_from_edge_idx ON map.vzla_restrictions USING btree (from_edge);CREATE INDEX vzla_restrictions_to_edge_idx ON map.vzla_restrictions USING btree (to_edge);I was checking table statistics and realize i put an effort to create index for vzla_rto, but looks like i didn't enough for vzla_restrictions.
| seq_scan | seq_tu_read | idx_scan | idx_tup_fetch | n_tup_insvzla_restrictions | 1,672,959 | 16,848,370,089 | - | - | 10071vzla_rto | 1,549 | 977,994,776 | 862,610,399 | 3,866,967,927 | 648968So which index should i add to vzla_restrictions to help pgr_trsp()?
أكثر...
vzla_rto have the links and nodes (650k)
vzla_restriction have the turn restrictions (10k)
CREATE TABLE map.vzla_restrictions( rid integer NOT NULL, to_cost numeric, to_edge integer, from_edge integer, via text);CREATE INDEX vzla_restrictions_from_edge_idx ON map.vzla_restrictions USING btree (from_edge);CREATE INDEX vzla_restrictions_to_edge_idx ON map.vzla_restrictions USING btree (to_edge);I was checking table statistics and realize i put an effort to create index for vzla_rto, but looks like i didn't enough for vzla_restrictions.
| seq_scan | seq_tu_read | idx_scan | idx_tup_fetch | n_tup_insvzla_restrictions | 1,672,959 | 16,848,370,089 | - | - | 10071vzla_rto | 1,549 | 977,994,776 | 862,610,399 | 3,866,967,927 | 648968So which index should i add to vzla_restrictions to help pgr_trsp()?
أكثر...