public inbox for [email protected]
help / color / mirror / Atom feedFrom: Peter Geoghegan <[email protected]>
To: Don Seiler <[email protected]>
Cc: Postgres General <[email protected]>
Subject: Re: Index Partition Size Double of its Table Partition?
Date: Wed, 30 Oct 2024 11:44:43 -0400
Message-ID: <CAH2-Wzki5sKPxi9OzS+ir+wHzygC5bM0+PZuTj-aXWNW1tnZiQ@mail.gmail.com> (raw)
In-Reply-To: <CAHJZqBBrXD5ca+BcoKSg0yBbehtos9Zt+zd0gN1J2L6xP+4jJg@mail.gmail.com>
References: <CAHJZqBA83fBGjqXqF+rVbErdy2N0_zDEiLWJMrDUSKjKQOZi3Q@mail.gmail.com>
<CAH2-Wzmq+ZLkYFLq-WGJhd=xJ0UosQMuLCMbHXKcKucwsSL=eg@mail.gmail.com>
<CAHJZqBBrXD5ca+BcoKSg0yBbehtos9Zt+zd0gN1J2L6xP+4jJg@mail.gmail.com>
On Wed, Oct 30, 2024 at 11:39 AM Don Seiler <[email protected]> wrote:
> Thanks Peter, I'll look into that shortly.
It sounds like you have no updates and deletes. Right? So the only
thing that could be different is the way that the pages are being
split (aside from variations in the width of index tuples, which seems
highly unlikely to be the only factor).
The heuristics used to trigger the relevant behavior are fairly
conservative. I wonder if we should be more aggressive about it.
> I should have also included that this is on PG 15 (currently 15.8 but we created the indexes when it was still 15.7) on Ubuntu 22.04 LTS.
That shouldn't matter, as far as this theory of mine is concerned.
Anything after 12 could be affected by the issue I'm thinking of.
--
Peter Geoghegan
view thread (5+ 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]
Subject: Re: Index Partition Size Double of its Table Partition?
In-Reply-To: <CAH2-Wzki5sKPxi9OzS+ir+wHzygC5bM0+PZuTj-aXWNW1tnZiQ@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