jmzk
jmzk copied to clipboard
Improvements on `postgres_plugin`
- Support partition in postgres (uses
pg_pathman).- Build
pg_pathmanintopostgresdocker image. Currently we use image from bitnami, maybe we need to build our one. - Update sql to create partition.
- Build
- Improve query performance
- Analysis current query sql to find the complex queries and add necessary indexes.
- Analysis partition performance impact.
- Support all the actions: Currently
postgres_plugindon't support all the actions(e.g. lock, bonus, suspend) processing.
These improvements are great, partition and indexs and very crucial for long-term data volume.