public inbox for [email protected]
help / color / mirror / Atom feedFrom: Rob Sargent <[email protected]>
To: Don Seiler <[email protected]>
Cc: David Mullineux <[email protected]>
Cc: Peter Geoghegan <[email protected]>
Cc: Postgres General <[email protected]>
Subject: Re: Index Partition Size Double of its Table Partition?
Date: Thu, 31 Oct 2024 10:13:03 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q@mail.gmail.com>
References: <CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q@mail.gmail.com>
--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 <[email protected]> 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 <<a href=3D"mailto:dmullx@gmai=
l.com">[email protected]</a>> 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 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--
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Index Partition Size Double of its Table Partition?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox