Re: reduce size of table partitioned

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sat, Jan 27, 2024 at 8:31 AM Erik Serrano <eserranos@xxxxxxxxx> wrote:
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??

Detaching and dropping will (as mentioned by Holger) certainly reduce the size of your partitioned table.

Remember, though, that you might have partitioned the table by some other key besides a date field.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux