...

  1. Scheduled-style mechanism

    This group of approaches is based on periodic scanning of all saved pieces and determining the status of poline on this basis. A typical algorithm for such mechanism might look as shown on Figure 1.

  2. Image Added

    Checking and updating the PO line status upon retrieving

    PostgreSQL Trigger Functions

    Vert.X Periodic Timer

    #_executing_periodic_and_delayed_actions

  3. Interceptor-style mechanisms

    Separate Scheduler Application

    PostgreSQL cron-job

    pg_cron

...