From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQL intenal scheduler? |
Date: | 2018-09-05 15:31:42 |
Message-ID: | b39bfe6a-c7ab-3ff7-f1c4-f2297f4626cb@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thiemo Kellner schrieb am 05.09.2018 um 17:06:
> I am designing a framework for historisation implementation (SCD).
> One feature I would like to provide is a table in that the actual
> state of an entity is put and if this is complete, this history table
> is "updated":
>
> ------------ -------------
> ==> | ENTITY_ACT | ==> | ENTITY_HIST |
> ------------ -------------
>
> I plan to use instead-of-triggers on the hist table that read the
> actual table and perfoms all necessary inserts und updates on the
> history table. If I want the termination of a record version
> (actually the record of a specific business key with a specific
> payload) to get propagated up and/or down referential integrities (no
> overlapping validities) I have to make sure that only one of those
> processes is modifying a table. I was thinking of a scheduler queue
> where the trigger would put a process request and PostgreSQL would
> work through. Is there a scheduler within PostgreSQL? I read the
> documentation and searched the web but could not find a hint. But
> before going another road or implementing something myself, I ask.
> Maybe this design is no good at all.
There is no built-in scheduler, but there is an extension that supplies that
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Poty | 2018-09-05 15:45:05 | Re: increasing HA |
Previous Message | Tim Clarke | 2018-09-05 15:09:04 | Re: PostgreSQL intenal scheduler? |