Postgres Pro
Downloads
Home   >   mailing lists

reduce size of table partitioned - Mailing list pgsql-admin

From Erik Serrano
Subject reduce size of table partitioned
Date
Msg-id CA+dvXXt_wt-z63WsPzO3i83-dauVwLzV3BCJUw6HUkP=ir7VkA@mail.gmail.com
Whole thread Raw
Responses Re: reduce size of table partitioned
Re: reduce size of table partitioned
List pgsql-admin
Tree view
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@gmail.com
                 998596691

pgsql-admin by date:

Previous
From: "Larson, Matthew"
Date:
Subject: Barman database recovery and collation version mismatch
Next
From: Holger Jakobs
Date:
Subject: Re: reduce size of table partitioned