Question on partitioning

From: veem v <veema0000(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Question on partitioning
Date: 2024-02-04 21:39:56
Message-ID: CAB+=1TUznj3Gk0EmUtahQVnc3AuvFFP2tqArWnWm+oBW4YJ7-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,
In postgresql, Is it possible to partition an existing nonpartitioned table
having data already residing in it and indexes and constraints defined in
it, without the need of manually moving the data around, to make it faster?
Similarly merging multiple partitions to one partition or splitting a
single partition into multiple partitions?
Appreciate any reference doc or sample syntax for the same.

Thanks and Regards
Veem

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lorusso Domenico 2024-02-04 22:50:33 select from composite type
Previous Message Lok P 2024-02-04 21:25:55 Re: How to do faster DML