Dear Postgres Family,
I need some clarity and suggestions on the situation below.There is a table called table_1
- its immutable only INSERTS allowed.
- it should get partitioned monthly basis
- partitions should be created while inserting data
- inheritance method should be used
Everything I have written with the Trigger Function.
Now My doubt is how I can do this INSERT routing better. It must be optimized for efficiency and handle concurrency.
Any thoughts?
Thanks,