| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: reduce size of table partitioned |
| Date: | 2024-01-28 17:14:29 |
| Message-ID: | CANzqJaDR8YnjXm2w0N9y519PsfC_jVQfOZu9ZqXNHSkOJLXxgQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, Jan 27, 2024 at 8:31 AM Erik Serrano <eserranos(at)gmail(dot)com> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2024-01-29 07:57:21 | Re: pg_dumpall and owner of the extension |
| Previous Message | Erik Serrano | 2024-01-28 15:11:44 | Re: reduce size of table partitioned |