Routing & Concurrency with trigger functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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,



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux