Re: Regarding performance regression on specific query

On Tue, Nov 20, 2018 at 10:08 PM Jung, Jinho <jinho.jung@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