Is there a way to have timezoned day partitions?

Community
1

Hi,
I am currently developing an app that handles iot data in a local facility. I have tables that store iot data that is partitioned by day. The partition is kept for a month and expired partitions are dropped by our scheduled worker.

I am trying to delete only the data that are ruled expired under the local timezone, which is “Asia/Seoul”, but since the table partitions follow UTC timezone, dropping partition ‘2025-05-18’ means dropping data from ‘2025-05-18 09:00:00 KST’ to ‘2025-05-19 08:59:59 KST’.

Is there a way to configure the partitions to be timezoned? Or if there are any suggestions for a workaround, I would greatly appreciate it.

Thanks.

2

Hi @SJC ,

Unfortunately not. It will be possible if you partition by hour, and then offset your drop range by 9 hours.

Otherwise, you can just hold a couple of extra days and delete them later on. Then just make sure your queries are bounded by Seoul time, so you don’t return this extra data.