MIME-Version: 1.0
References: 
 <CAOC+FBXR59QvEvpnOj0d0Om352i=2gP_Mm+b=aeQ4Zo3w-gNdA@mail.gmail.com>
In-Reply-To: 
 <CAOC+FBXR59QvEvpnOj0d0Om352i=2gP_Mm+b=aeQ4Zo3w-gNdA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 12 Sep 2024 19:47:03 -0400
Message-ID: 
 <CANzqJaDi90pp=cq5kuTnewstkV5E30ToYu2eW-_yTrN0UJkJuw@mail.gmail.com>
Subject: Re: Query plan getting less efficient over time with frequent updates
 and deletes..
To: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e476630621f4b943"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaDi90pp%3Dcq5kuTnewstkV5E30ToYu2eW-_yTrN0UJkJuw%40mail.gmail.com>
Precedence: bulk

--000000000000e476630621f4b943
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Sep 12, 2024 at 6:52=E2=80=AFPM Wells Oliver <wells.oliver@gmail.co=
m> 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. Th=
is
> 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 tabl=
e
> because I can't quite figure out why querying gets bogged down. The vacuu=
m
> 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.

--000000000000e476630621f4b943
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Sep 12, 2024 at 6:52=E2=80=AFPM W=
ells Oliver &lt;<a href=3D"mailto:wells.oliver@gmail.com">wells.oliver@gmai=
l.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div style=3D"font-size:s=
mall">Hi all: we have a table which receives frequent daily updates and del=
etes 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.</div><div style=3D"font-size:small"><br></div><=
div style=3D"font-size:small">I&#39;ve been in the habit of using pg_repack=
 maybe once a month on this table because I can&#39;t quite figure out why =
querying gets bogged down. The vacuum and analyze thresholds are set such t=
hat the table is both auto vacuumed and analyzed every night.</div></div></=
blockquote><div>=C2=A0</div><div>1. You&#39;re absolutely positive that the=
 VACUUM and ANALYZE complete every night?</div><div>2. Nightly may not be o=
ften enough.</div></div><br></div>

--000000000000e476630621f4b943--