Re: Query plan getting less efficient over time with frequent updates and deletes..

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Query plan getting less efficient over time with frequent updates and deletes..
Date: 2024-09-12 23:47:03
Message-ID: CANzqJaDi90pp=cq5kuTnewstkV5E30ToYu2eW-_yTrN0UJkJuw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2024-09-12 23:56:21 Re: Query plan getting less efficient over time with frequent updates and deletes..
Previous Message Wells Oliver 2024-09-12 22:51:50 Query plan getting less efficient over time with frequent updates and deletes..