Re: Create Partitions ! - Mailing list pgsql-admin

From Kashif Zeeshan
Subject Re: Create Partitions !
Date
Msg-id CAAPsdhcX-dSff5HqOiEdzvSPToLZNCOw5xzWWZWy1BaSa=i+ow@mail.gmail.com
Whole thread Raw
In response to Create Partitions !  (rocky user <madhavjpn567@gmail.com>)
List pgsql-admin
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

Regards
Kashif Zeeshan
   

On Thu, Jul 11, 2024 at 9:39 PM rocky user <madhavjpn567@gmail.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.

pgsql-admin by date:

Previous
From: rocky user
Date:
Subject: Create Partitions !
Next
From: Holger Jakobs
Date:
Subject: Re: Better way to find long-running queries?