MIME-Version: 1.0
References: <CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q@mail.gmail.com>
 <A9B07796-4EBF-41F4-BA3E-2F7EC894A274@gmail.com>
In-Reply-To: <A9B07796-4EBF-41F4-BA3E-2F7EC894A274@gmail.com>
From: Don Seiler <don@seiler.us>
Date: Wed, 6 Nov 2024 21:41:02 -0600
Message-ID: <CAHJZqBAkQ7r25SBvsREH5TrVoUoA83XCLbUEv9maiJaNSz6H4A@mail.gmail.com>
Subject: Re: Index Partition Size Double of its Table Partition?
To: Rob Sargent <robjsargent@gmail.com>
Cc: David Mullineux <dmullx@gmail.com>, Peter Geoghegan <pg@bowt.ie>, 
	Postgres General <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f0dd6c06264a6722"
Archived-At: <https://www.postgresql.org/message-id/CAHJZqBAkQ7r25SBvsREH5TrVoUoA83XCLbUEv9maiJaNSz6H4A%40mail.gmail.com>
Precedence: bulk

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

On Thu, Oct 31, 2024 at 11:13=E2=80=AFAM Rob Sargent <robjsargent@gmail.com=
> wrote:

> Whats the fill factor?
>

No fill factor is specified, so I'm assuming it's the default 90% for
indexes.

FYI we did a REINDEX for the index in question tonight. Since the index was
for last month, there are no more writes to it so we didn't use
CONCURRENTLY either. The size went from 83GB to 48GB, which also happens to
be the size of the table partition.

--=20
Don Seiler
www.seiler.us

--000000000000f0dd6c06264a6722
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 Thu, Oct 31, 2024 at 11:13=E2=80=AFAM Rob Sargent &lt;<a href=3D"=
mailto:robjsargent@gmail.com">robjsargent@gmail.com</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div d=
ir=3D"ltr"></div>Whats the fill factor?</div></blockquote></div><div><br></=
div><div>No fill factor is specified, so I&#39;m assuming it&#39;s the defa=
ult 90% for indexes.</div><div><br></div><div>FYI we did a REINDEX for the =
index in question tonight. Since the index was for last month, there are no=
 more writes to it so we didn&#39;t use CONCURRENTLY either. The size went =
from 83GB to 48GB, which also happens to be the size of the table partition=
.<br clear=3D"all"></div><br><span class=3D"gmail_signature_prefix">-- </sp=
an><br><div dir=3D"ltr" class=3D"gmail_signature"><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>

--000000000000f0dd6c06264a6722--