| From: | Don Seiler <don(at)seiler(dot)us> |
|---|---|
| To: | David Mullineux <dmullx(at)gmail(dot)com> |
| Cc: | Peter Geoghegan <pg(at)bowt(dot)ie>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index Partition Size Double of its Table Partition? |
| Date: | 2024-10-31 16:01:55 |
| Message-ID: | CAHJZqBCgQTAsmBhWMXYWSaysgi6a2c5GuQOO_eXE0RTj82cN8Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Oct 30, 2024 at 4:59 PM David Mullineux <dmullx(at)gmail(dot)com> wrote:
> Are you able to cluster the table ? The idea is that rows ordered in the
> same way as the index might reduce it's size ?
>
I'm not sure on this. There are other indexes on these table partitions as
well.
Another bit of useful info that I should have shared immediately is that
this is a monthly partitioned table, going back years. We don't drop old
partitions (yet) on this one. For now we've only added this index to a few
individual partitions. The hope was to add it to all of them and then
eventually the template (using an older version of pg_partman).
Don.
--
Don Seiler
www.seiler.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2024-10-31 16:13:03 | Re: Index Partition Size Double of its Table Partition? |
| Previous Message | Laurenz Albe | 2024-10-31 13:11:04 | Re: pg_wal folder high disk usage |