Re: reduce size of table partitioned

Holger Jakobs <holger@xxxxxxxxxx> · Sat, 27 Jan 2024 15:00:02 +0100



    Am 27.01.24 um 14:31 schrieb Erik
      Serrano:

    
      Dear All,

        
        Good morning, I have a small doubt regarding a partitioned
        table, which has its "mother" table and many "daughter" tables,
        well the main question is... I need to reduce the size of my
        partitioned table, I can simply delete ( drop table) the oldest
        daughter tables??? or it is not recommended....or maybe there is
        another method to do this??

        
        From already thank you very much

        Greetings

        
                      Erik R. Serrano Saavedra
                      Ingeniero de
                            Sistemas Informáticos
                            Data
                            Base Administrator
                              eserranos@xxxxxxxxx

                          
                                       998596691

                      
    see here:

https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-OVERVIEW
    Dropping an individual partition
      using DROP TABLE, or doing ALTER TABLE DETACH PARTITION, is far
      faster than a bulk operation. These commands also entirely avoid
      the VACUUM overhead caused by a bulk
      DELETE.
    

    -- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
  

Attachment:
OpenPGP_signature

Description: OpenPGP digital signature