Dear Postgres Family,
I need some clarity and suggestions on the situation below.
There is a table called table_1
1. its immutable only INSERTS allowed.
2. it should get partitioned monthly basis
3. partitions should be created while inserting data
4. 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,