Routing & Concurrency with trigger functions

Поиск
Список
Период
Сортировка
От chanukya SDS
Тема Routing & Concurrency with trigger functions
Дата
Msg-id CAB4f4B4bcyfsjtBTADZw51fNacPgjOVPWpr3kLv1KnYDLh1wHQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-performance
Дерево обсуждения
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,


В списке pgsql-performance по дате отправления:

Предыдущее
От: Craig Jackson
Дата:
Сообщение: Re: Database Stalls
Следующее
От: Mark Hills
Дата:
Сообщение: Domain check taking place unnecessarily?