Re: Create Partitions !

Hi Rocky

Yes, it is possible to partition an existing table with millions of records
based on a specific column, even if that column has VARCHAR values.

Please refer to following
https://rodoq.medium.com/partition-an-existing-table-on-postgresql-480b84582e8d
https://dba.stackexchange.com/questions/106014/how-to-partition-existing-table-in-postgres

Regards
Kashif Zeeshan

On Thu, Jul 11, 2024 at 9:39 PM rocky user <madhavjpn567(at)gmail(dot)com> wrote:

> I have a table which has around 300 millions of records and this table,
> Every minute there would be a lot of huge writes and reads on this data.
> So, I don't see there were any partitions created on this table. So, is it
> a possible case that I can create partitions on the already existing table
> which has millions of records based on certain column which has some list
> of values under it and those list of that column is being used in my WHERE
> clause in the SELECT statement.
> Values are Varchar for that column. They are list distinct 10 values
> that can repeat.
>