• Alvaro Herrera's avatar
    Revert analyze support for partitioned tables · b3d24cc0
    Alvaro Herrera authored
    This reverts the following commits:
    1b5617eb Describe (auto-)analyze behavior for partitioned tables
    0e69f705 Set pg_class.reltuples for partitioned tables
    41badeab Document ANALYZE storage parameters for partitioned tables
    0827e8af autovacuum: handle analyze for partitioned tables
    
    There are efficiency issues in this code when handling databases with
    large numbers of partitions, and it doesn't look like there isn't any
    trivial way to handle those.  There are some other issues as well.  It's
    now too late in the cycle for nontrivial fixes, so we'll have to let
    Postgres 14 users continue to manually deal with ANALYZE their
    partitioned tables, and hopefully we can fix the issues for Postgres 15.
    
    I kept [most of] be280cda ("Don't reset relhasindex for partitioned
    tables on ANALYZE") because while we added it due to 0827e8af, it is
    a good bugfix in its own right, since it affects manual analyze as well
    as autovacuum-induced analyze, and there's no reason to revert it.
    
    I retained the addition of relkind 'p' to tables included by
    pg_stat_user_tables, because reverting that would require a catversion
    bump.
    Also, in pg14 only, I keep a struct member that was added to
    PgStat_TabStatEntry to avoid breaking compatibility with existing stat
    files.
    
    Backpatch to 14.
    
    Discussion: https://postgr.es/m/20210722205458.f2bug3z6qzxzpx2s@alap3.anarazel.de
    b3d24cc0
reloptions.c 55.4 KB