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,