On Tue, Nov 20, 2018 at 10:08 PM Jung, Jinho <jinho.j...@gatech.edu> wrote: > We are wondering how ANALYZE mitigated regression from query "1.sql" and > "4.sql". > > We followed this procedure but still observe performance regression: > 1) run ANALYZE on used table_name > analyze pg_catalog.pg_ts_parser; > analyze information_schema.column_options; > analyze pg_catalog.pg_aggregate; > analyze pg_catalog.pg_inherits; > analyze pg_catalog.pg_aggregate; > analyze pg_catalog.pg_rewrite; > analyze pg_catalog.pg_stat_user_indexes; > analyze pg_catalog.pg_stat_user_tables; > analyze pg_catalog.pg_attribute; > analyze information_schema.column_privileges; > analyze pg_catalog.pg_user_mapping; > analyze pg_catalog.pg_type; > analyze pg_catalog.pg_shseclabel; > analyze pg_catalog.pg_statio_sys_sequences; > analyze information_schema.role_routine_grants; > analyze pg_catalog.pg_type; > analyze information_schema.user_mapping_options; > analyze pg_catalog.pg_stat_xact_sys_tables;
You can run ANALYZE without explicitly specifying any table name, so that you don't miss any. > We have more cases. Do you think we should report them through the bug report > website? (https://www.postgresql.org/account/login/?next=/account/submitbug/) You can send an email to pgsql-performance mailing list. https://www.postgresql.org/list/pgsql-performance/ Thanks, Amit
