jmzk icon indicating copy to clipboard operation
jmzk copied to clipboard

Improvements on `postgres_plugin`

Open harrywong opened this issue 6 years ago • 1 comments

  1. Support partition in postgres (uses pg_pathman).
    • Build pg_pathman into postgres docker image. Currently we use image from bitnami, maybe we need to build our one.
    • Update sql to create partition.
  2. Improve query performance
    • Analysis current query sql to find the complex queries and add necessary indexes.
    • Analysis partition performance impact.
  3. Support all the actions: Currently postgres_plugin don't support all the actions(e.g. lock, bonus, suspend) processing.

harrywong avatar Feb 15 '19 05:02 harrywong

These improvements are great, partition and indexs and very crucial for long-term data volume.

ceeji avatar Feb 17 '19 15:02 ceeji