| From: | Erik Serrano <eserranos(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | reduce size of table partitioned |
| Date: | 2024-01-27 13:31:10 |
| Message-ID: | CA+dvXXt_wt-z63WsPzO3i83-dauVwLzV3BCJUw6HUkP=ir7VkA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)gmail(dot)com <eserranos(at)gmail(dot)com>*
* 998596691*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2024-01-27 14:00:02 | Re: reduce size of table partitioned |
| Previous Message | Larson, Matthew | 2024-01-26 22:30:14 | Barman database recovery and collation version mismatch |