On Thu, Sep 12, 2024 at 6:52 PM Wells Oliver <wells(dot)oliver(at)gmail(dot)com> wrote:
> Hi all: we have a table which receives frequent daily updates and deletes
> on the order of 100-600k. The overall row length is approximately 80m. This
> table has 50 indexes and 303 columns and is quite frequently queried by
> humans and applications.
>
> I've been in the habit of using pg_repack maybe once a month on this table
> because I can't quite figure out why querying gets bogged down. The vacuum
> and analyze thresholds are set such that the table is both auto vacuumed
> and analyzed every night.
>
1. You're absolutely positive that the VACUUM and ANALYZE complete every
night?
2. Nightly may not be often enough.