Postgres Pro
Downloads
Home   >   mailing lists

Re: Query plan getting less efficient over time with frequent updates and deletes.. - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Query plan getting less efficient over time with frequent updates and deletes..
Date
Msg-id CANzqJaDi90pp=cq5kuTnewstkV5E30ToYu2eW-_yTrN0UJkJuw@mail.gmail.com
Whole thread Raw
In response to Query plan getting less efficient over time with frequent updates and deletes..  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Query plan getting less efficient over time with frequent updates and deletes..
List pgsql-admin
Tree view
On Thu, Sep 12, 2024 at 6:52 PM Wells Oliver <wells.oliver@gmail.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.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Query plan getting less efficient over time with frequent updates and deletes..
Next
From: Wells Oliver
Date:
Subject: Re: Query plan getting less efficient over time with frequent updates and deletes..