Content-Type: multipart/alternative; boundary=Apple-Mail-BFA07331-786C-46B7-95ED-890100B3C86D
Content-Transfer-Encoding: 7bit
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Index Partition Size Double of its Table Partition?
Date: Thu, 31 Oct 2024 10:13:03 -0600
Message-Id: <A9B07796-4EBF-41F4-BA3E-2F7EC894A274@gmail.com>
References: <CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q@mail.gmail.com>
Cc: David Mullineux <dmullx@gmail.com>, Peter Geoghegan <pg@bowt.ie>,
 Postgres General <pgsql-general@postgresql.org>
In-Reply-To: <CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q@mail.gmail.com>
To: Don Seiler <don@seiler.us>
Archived-At: <https://www.postgresql.org/message-id/A9B07796-4EBF-41F4-BA3E-2F7EC894A274%40gmail.com>
Precedence: bulk


--Apple-Mail-BFA07331-786C-46B7-95ED-890100B3C86D
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr"><br=
></div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Oct 31, 2024, at 10=
:02=E2=80=AFAM, Don Seiler &lt;don@seiler.us&gt; wrote:<br><br></blockquote>=
</div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D"ltr"><=
div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Oct 3=
0, 2024 at 4:59=E2=80=AFPM David Mullineux &lt;<a href=3D"mailto:dmullx@gmai=
l.com">dmullx@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><p dir=3D"ltr">Are you able to cluster the table ? The i=
dea is that rows ordered in the same way&nbsp; as the index might reduce it'=
s size ? </p></blockquote><div>I'm not sure 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 shared immediately is that this is a mont=
hly partitioned table, going back years. We don't drop old partitions (yet) o=
n this one. For now we've only added this index to a few individual partitio=
ns. 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></d=
iv></div><span class=3D"gmail_signature_prefix">-- </span><br></div></div></=
blockquote>Whats the fill factor?<div><br></div></body></html>=

--Apple-Mail-BFA07331-786C-46B7-95ED-890100B3C86D--