Skip to content

Instantly share code, notes, and snippets.

@wkalt

wkalt/gist:42792c53a5dc9f0840c4

Created August 21, 2014 00:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wkalt/42792c53a5dc9f0840c4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wkalt/42792c53a5dc9f0840c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
2000 nodes, 100 facts per node, 85% duplicated
NO INDEX INDEX
schema | name | size | index | ratio | total schema | name | size | index | ratio | total
--------------------+------------------------------------+------------+---------+-------+--------- --------------------+------------------------------------+------------+---------+-------+---------
public | facts | 25 MB | 25 MB | 50% | 50 MB public | facts | 25 MB | 25 MB | 50% | 50 MB
public | fact_paths | 8712 kB | 18 MB | 68% | 26 MB public | fact_paths | 8712 kB | 33 MB | 80% | 42 MB
public | facts_factset_id_fact_value_id_key | 0 bytes | 25 MB | 100% | 25 MB public | fact_values | 11 MB | 15 MB | 57% | 26 MB
public | fact_values | 11 MB | 11 MB | 50% | 23 MB public | facts_factset_id_fact_value_id_key | 0 bytes | 25 MB | 100% | 25 MB
public | fact_values_path_id_value_key | 0 bytes | 9464 kB | 100% | 9464 kB public | fact_paths_path_trgm | 0 bytes | 16 MB | 100% | 16 MB
public | fact_paths_path_type_id_key | 0 bytes | 7760 kB | 100% | 7760 kB public | fact_values_path_id_value_key | 0 bytes | 9464 kB | 100% | 9464 kB
public | fact_paths_name | 0 bytes | 3512 kB | 100% | 3512 kB public | fact_paths_path_type_id_key | 0 bytes | 7760 kB | 100% | 7760 kB
public | fact_paths_value_type_id | 0 bytes | 2440 kB | 100% | 2440 kB public | fact_values_string_trgm | 0 bytes | 3976 kB | 100% | 3976 kB
public | fact_paths_depth | 0 bytes | 2400 kB | 100% | 2400 kB public | fact_paths_name | 0 bytes | 3512 kB | 100% | 3512 kB
public | fact_paths_pkey | 0 bytes | 1920 kB | 100% | 1920 kB public | fact_paths_value_type_id | 0 bytes | 2440 kB | 100% | 2440 kB
public | fact_values_pkey | 0 bytes | 1920 kB | 100% | 1920 kB public | fact_paths_depth | 0 bytes | 2400 kB | 100% | 2400 kB
pg_catalog | pg_depend | 408 kB | 544 kB | 58% | 952 kB public | fact_paths_pkey | 0 bytes | 1920 kB | 100% | 1920 kB
pg_catalog | pg_proc | 504 kB | 312 kB | 39% | 816 kB public | fact_values_pkey | 0 bytes | 1920 kB | 100% | 1920 kB
pg_catalog | pg_attribute | 464 kB | 288 kB | 39% | 752 kB pg_catalog | pg_depend | 416 kB | 560 kB | 58% | 976 kB
pg_catalog | pg_rewrite | 88 kB | 448 kB | 84% | 536 kB pg_catalog | pg_proc | 504 kB | 312 kB | 39% | 816 kB
public | factsets | 328 kB | 184 kB | 36% | 512 kB pg_catalog | pg_attribute | 464 kB | 288 kB | 39% | 752 kB
public | environments | 312 kB | 184 kB | 38% | 496 kB pg_catalog | pg_rewrite | 88 kB | 448 kB | 84% | 536 kB
pg_catalog | pg_statistic | 208 kB | 256 kB | 56% | 464 kB public | factsets | 328 kB | 184 kB | 36% | 512 kB
pg_catalog | pg_description | 248 kB | 168 kB | 41% | 416 kB public | environments | 312 kB | 184 kB | 38% | 496 kB
pg_toast | pg_toast_2618 | 336 kB | 48 kB | 13% | 384 kB pg_catalog | pg_statistic | 208 kB | 256 kB | 56% | 464 kB
pg_catalog | pg_depend_reference_index | 0 bytes | 264 kB | 100% | 264 kB pg_catalog | pg_description | 248 kB | 168 kB | 41% | 416 kB
pg_catalog | pg_shdepend | 8192 bytes | 240 kB | 97% | 248 kB pg_toast | pg_toast_2618 | 336 kB | 48 kB | 13% | 384 kB
pg_catalog | pg_depend_depender_index | 0 bytes | 248 kB | 100% | 248 kB pg_catalog | pg_depend_reference_index | 0 bytes | 272 kB | 100% | 272 kB
public | certnames | 112 kB | 128 kB | 54% | 240 kB pg_catalog | pg_depend_depender_index | 0 bytes | 256 kB | 100% | 256 kB
pg_catalog | pg_class | 128 kB | 112 kB | 47% | 240 kB pg_catalog | pg_shdepend | 8192 bytes | 240 kB | 97% | 248 kB
pg_catalog | pg_operator | 112 kB | 112 kB | 50% | 224 kB public | certnames | 112 kB | 128 kB | 54% | 240 kB
pg_catalog | pg_proc_proname_args_nsp_index | 0 bytes | 200 kB | 100% | 200 kB pg_catalog | pg_class | 128 kB | 112 kB | 47% | 240 kB
pg_catalog | pg_shdepend_depender_index | 168 kB | 24 kB | 13% | 192 kB pg_catalog | pg_operator | 112 kB | 112 kB | 50% | 224 kB
pg_toast | pg_toast_2619 | 136 kB | 48 kB | 27% | 184 kB pg_catalog | pg_proc_proname_args_nsp_index | 0 bytes | 200 kB | 100% | 200 kB
pg_catalog | pg_type | 80 kB | 104 kB | 57% | 184 kB pg_catalog | pg_type | 88 kB | 104 kB | 55% | 192 kB
pg_catalog | pg_amop | 32 kB | 128 kB | 80% | 160 kB pg_catalog | pg_shdepend_depender_index | 168 kB | 24 kB | 13% | 192 kB
pg_catalog | pg_collation | 72 kB | 80 kB | 53% | 152 kB pg_toast | pg_toast_2619 | 136 kB | 48 kB | 27% | 184 kB
pg_catalog | pg_attribute_relid_attnam_index | 0 bytes | 152 kB | 100% | 152 kB pg_catalog | pg_amop | 32 kB | 128 kB | 80% | 160 kB
pg_catalog | pg_description_o_c_o_index | 0 bytes | 128 kB | 100% | 128 kB pg_catalog | pg_attribute_relid_attnam_index | 0 bytes | 152 kB | 100% | 152 kB
pg_catalog | pg_constraint | 24 kB | 104 kB | 82% | 128 kB pg_catalog | pg_collation | 72 kB | 80 kB | 53% | 152 kB
pg_catalog | pg_trigger | 24 kB | 88 kB | 79% | 112 kB pg_catalog | pg_constraint | 24 kB | 104 kB | 82% | 128 kB
pg_catalog | pg_conversion | 24 kB | 80 kB | 77% | 104 kB pg_catalog | pg_description_o_c_o_index | 0 bytes | 128 kB | 100% | 128 kB
pg_catalog | pg_amproc | 24 kB | 80 kB | 77% | 104 kB pg_catalog | pg_trigger | 24 kB | 88 kB | 79% | 112 kB
pg_catalog | pg_attribute_relid_attnum_index | 0 bytes | 104 kB | 100% | 104 kB pg_catalog | pg_conversion | 24 kB | 80 kB | 77% | 104 kB
pg_catalog | pg_index | 40 kB | 64 kB | 62% | 104 kB pg_catalog | pg_attribute_relid_attnum_index | 0 bytes | 104 kB | 100% | 104 kB
information_schema | sql_features | 56 kB | 40 kB | 42% | 96 kB pg_catalog | pg_amproc | 24 kB | 80 kB | 77% | 104 kB
public | factsets_certname_idx | 0 bytes | 88 kB | 100% | 88 kB pg_catalog | pg_index | 40 kB | 64 kB | 62% | 104 kB
public | certnames_pkey | 0 bytes | 88 kB | 100% | 88 kB information_schema | sql_features | 56 kB | 40 kB | 42% | 96 kB
public | environments_name_key | 0 bytes | 88 kB | 100% | 88 kB public | certnames_pkey | 0 bytes | 88 kB | 100% | 88 kB
pg_catalog | pg_cast | 16 kB | 64 kB | 80% | 80 kB public | factsets_certname_idx | 0 bytes | 88 kB | 100% | 88 kB
pg_catalog | pg_opfamily | 16 kB | 64 kB | 80% | 80 kB public | environments_name_key | 0 bytes | 88 kB | 100% | 88 kB
pg_catalog | pg_opclass | 16 kB | 64 kB | 80% | 80 kB pg_catalog | pg_cast | 16 kB | 64 kB | 80% | 80 kB
pg_catalog | pg_ts_config_map | 16 kB | 64 kB | 80% | 80 kB pg_catalog | pg_opfamily | 16 kB | 64 kB | 80% | 80 kB
pg_catalog | pg_tablespace | 8192 bytes | 64 kB | 89% | 72 kB pg_catalog | pg_opclass | 16 kB | 64 kB | 80% | 80 kB
public | resource_events | 0 bytes | 72 kB | 100% | 72 kB pg_catalog | pg_ts_config_map | 16 kB | 64 kB | 80% | 80 kB
(50 rows) (50 rows)
PATHS QUERY PATHS QUERY
path ~ '^networking#~eth[0-9]#~(?:((?!\#\~).)+|.?)$'
2000/no 2000/yes
121.242 77.381
118.650 75.196
118.835 74.101
119.654 74.034
120.843 73.372
119.465 73.843
122.245 72.852
120.855 73.705
117.954 72.628
128.996 73.318
124.236 74.092
118.154 73.262
120.108 73.942
117.885 77.162
117.614 75.902
125.095 74.894
122.902 109.221
121.554 75.857
117.614 72.750
116.879 73.994
129.437 73.346
127.424 74.067
119.005 76.642
122.387 77.969
121.910 73.694
mean 121.2377 mean 75.88896 improvement 37%
VALUE STRING VALUE STRING
value_string ~ '192.*'
2000/no 2000/yes
38.705 5.449
38.038 5.651
37.602 5.642
38.211 5.588
39.917 5.396
38.197 5.401
38.065 5.425
37.479 5.543
36.348 5.277
36.903 5.655
41.361 5.617
38.517 5.471
38.201 5.637
37.138 5.319
37.121 5.481
37.032 5.352
38.103 5.589
37.415 5.447
36.765 5.451
37.225 5.440
37.386 5.435
38.359 5.709
37.414 5.341
36.817 5.368
38.438 5.369
mean 37.87 mean 5.48 improvement 85.5%
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment