Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pathman creates the same partition #213

Open
LJXLJX1 opened this issue Jun 29, 2020 · 3 comments
Open

pathman creates the same partition #213

LJXLJX1 opened this issue Jun 29, 2020 · 3 comments

Comments

@LJXLJX1
Copy link

LJXLJX1 commented Jun 29, 2020

Problem description

pathman creates the same partition

Environment

@LJXLJX1
Copy link
Author

LJXLJX1 commented Jun 29, 2020

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
Copy link
Author

LJXLJX1 commented Jun 29, 2020

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
Copy link

MHXXX commented Sep 29, 2020

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants