MIME-Version: 1.0
References: <CAHJZqBA83fBGjqXqF+rVbErdy2N0_zDEiLWJMrDUSKjKQOZi3Q@mail.gmail.com>
 <CAH2-Wzmq+ZLkYFLq-WGJhd=xJ0UosQMuLCMbHXKcKucwsSL=eg@mail.gmail.com>
 <CAHJZqBBrXD5ca+BcoKSg0yBbehtos9Zt+zd0gN1J2L6xP+4jJg@mail.gmail.com>
 <CAH2-Wzki5sKPxi9OzS+ir+wHzygC5bM0+PZuTj-aXWNW1tnZiQ@mail.gmail.com>
 <CAHJZqBDhGmMCTp-7bDXDq4k-b625G0r00VXx1wH0=kLEcetDhQ@mail.gmail.com>
 <CAH2-WznOOfi5L9TmeyzFT+-Hs23edNmJerDzFaRWGE5X0rJD=g@mail.gmail.com>
 <CAHJZqBCgYwWns2cRsbk5NWnLHXmmQPdKn7A+dknbA2sWH5TCUQ@mail.gmail.com> <CAGsyd8WXZr5-SaAnf2J7MiJheWfxrWTp9+fFhBgB8z93dPC_Vw@mail.gmail.com>
In-Reply-To: <CAGsyd8WXZr5-SaAnf2J7MiJheWfxrWTp9+fFhBgB8z93dPC_Vw@mail.gmail.com>
From: Don Seiler <don@seiler.us>
Date: Thu, 31 Oct 2024 11:01:55 -0500
Message-ID: <CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q@mail.gmail.com>
Subject: Re: Index Partition Size Double of its Table Partition?
To: David Mullineux <dmullx@gmail.com>
Cc: Peter Geoghegan <pg@bowt.ie>, Postgres General <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b8fd530625c7f04c"
Archived-At: <https://www.postgresql.org/message-id/CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q%40mail.gmail.com>
Precedence: bulk

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

On Wed, Oct 30, 2024 at 4:59=E2=80=AFPM David Mullineux <dmullx@gmail.com> =
wrote:

> Are you able to cluster the table ? The idea is that rows ordered in the
> same way  as the index might reduce it's size ?
>
I'm not sure on this. There are other indexes on these table partitions as
well.

Another bit of useful info that I should have shared immediately is that
this is a monthly partitioned table, going back years. We don't drop old
partitions (yet) on this one. For now we've only added this index to a few
individual partitions. The hope was to add it to all of them and then
eventually the template (using an older version of pg_partman).

Don.
--=20
Don Seiler
www.seiler.us

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

<div dir=3D"ltr"><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail=
_attr">On Wed, Oct 30, 2024 at 4:59=E2=80=AFPM David Mullineux &lt;<a href=
=3D"mailto:dmullx@gmail.com">dmullx@gmail.com</a>&gt; wrote:<br></div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><p dir=3D"ltr">Are you able to=
 cluster the table ? The idea is that rows ordered in the same way=C2=A0 as=
 the index might reduce it&#39;s size ? </p></blockquote><div>I&#39;m not s=
ure on this. There are other indexes on these table partitions as well.<br>=
</div><div><br></div><div>Another bit of useful info that I should have sha=
red immediately is that this is a monthly partitioned table, going back yea=
rs. We don&#39;t drop old partitions (yet) on this one. For now we&#39;ve o=
nly added this index to a few individual partitions. The hope was to add it=
 to all of them and then eventually the template (using an older version of=
 pg_partman).</div><div><br></div><div>Don. <br></div></div><span class=3D"=
gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signa=
ture"><div dir=3D"ltr"><div>Don Seiler<br><a href=3D"http://www.seiler.us" =
target=3D"_blank">www.seiler.us</a></div></div></div></div>

--000000000000b8fd530625c7f04c--