Re: Regarding performance regression on specific query

On Tue, Nov 20, 2018 at 10:08 PM Jung, Jinho <jinho(dot)jung(at)gatech(dot)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