Postgres Pro
Downloads
Home   >   mailing lists

Re: Index Partition Size Double of its Table Partition? - Mailing list pgsql-general

From Don Seiler
Subject Re: Index Partition Size Double of its Table Partition?
Date
Msg-id CAHJZqBAkQ7r25SBvsREH5TrVoUoA83XCLbUEv9maiJaNSz6H4A@mail.gmail.com
Whole thread Raw
In response to Re: Index Partition Size Double of its Table Partition?  (Don Seiler <don@seiler.us>)
List pgsql-general
Tree view
On Thu, Oct 31, 2024 at 11:13 AM 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.

--
Don Seiler
www.seiler.us

pgsql-general by date:

Previous
From: David Mullineux
Date:
Subject: Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16
Next
From: Torsten Förtsch
Date:
Subject: Re: Trouble using pg_rewind to undo standby promotion