search

postgrespro / pg_pathman

Partitioning tool for PostgreSQL
Other
585 stars 68 forks source link

pathman creates the same partition #213

Open LJXLJX1 opened 4 years ago

LJXLJX1 commented 4 years ago

Problem description

pathman creates the same partition

Environment

LJXLJX1 commented 4 years ago

pg_pathman 1.5

db_zenap_pm_db_zenap=# select * from pathman_partition_list where parent = 532635;

cnngcxgwe05124 | cnngcxgwe05124_166 | 2 | begintime | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 cnngcxgwe05124 | cnngcxgwe05124_167 | 2 | begintime | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 cnngcxgwe05124 | cnngcxgwe05124_168 | 2 | begintime | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 cnngcxgwe05124 | cnngcxgwe05124_169 | 2 | begintime | 2020-06-26 00:00:00 | 2020-06-27 00:00:00

LJXLJX1 commented 4 years ago

cnngcxgwe05124 | cnngcxgwe05124_167 | 2 | begintime | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 cnngcxgwe05124 | cnngcxgwe05124_168 | 2 | begintime | 2020-06-25 00:00:00 | 2020-06-26 00:00:00

MHXXX commented 4 years ago
The same problem i encountered parent partition parttype expr range_min range_max
d_face_recognition d_face_recognition_1066 2 countdate 2020-09-24 2020-09-25
d_face_recognition d_face_recognition_1067 2 countdate 2020-09-24 2020-09-25
d_face_recognition d_face_recognition_1058 2 countdate 2020-09-17 2020-09-18
d_face_recognition d_face_recognition_1059 2 countdate 2020-09-17 2020-09-18

This resulted in the data being stored in two tables separately,and small amount of data in 1067 and 1059,large amounts of data in 1066 and 1058

The database uses Alibaba Cloud's RDS database,datebase's version is PostgreSQL 10.10