public inbox for [email protected]
help / color / mirror / Atom feedFrom: Don Seiler <[email protected]>
To: Rob Sargent <[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: Wed, 6 Nov 2024 21:41:02 -0600
Message-ID: <CAHJZqBAkQ7r25SBvsREH5TrVoUoA83XCLbUEv9maiJaNSz6H4A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q@mail.gmail.com>
<[email protected]>
On Thu, Oct 31, 2024 at 11:13 AM Rob Sargent <[email protected]> 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.
--
Don Seiler
www.seiler.us
view thread (6+ messages)
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: <CAHJZqBAkQ7r25SBvsREH5TrVoUoA83XCLbUEv9maiJaNSz6H4A@mail.gmail.com>
* 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