Horton
Menu

Re: Index Partition Size Double of its Table Partition?

Rob Sargent <robjsargent@gmail.com>

View thread
From: Rob Sargent <robjsargent@gmail.com>
To: Don Seiler <don@seiler.us>
Cc: David Mullineux <dmullx@gmail.com>, Peter Geoghegan <pg@bowt.ie>, Postgres General <pgsql-general@postgresql.org>
Date: 2024-10-31T16:13:03Z
Lists: pgsql-general 

  



  

  
    On Oct 31, 2024, at 10:02 AM, Don Seiler <don@seiler.us> wrote:

    

  


  
    
    
      
        
          On Wed, Oct 30, 2024 at 4:59 PM David Mullineux <dmullx@gmail.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.

        
      --

    
  
Whats the fill factor?