Re: Storing state machine

2021-04-18 Thread Tim Cross
Mohan Radhakrishnan writes: > Hello, >We have a workflow when we receive events into the service. But we > don't have a way to choreograph or orchestrate the workflow. The > services are all independent and receive and respond to events. > > Since there is no order imposed by the e

Storing state machine

2021-04-18 Thread Mohan Radhakrishnan
Hello, We have a workflow when we receive events into the service. But we don't have a way to choreograph or orchestrate the workflow. The services are all independent and receive and respond to events. Since there is no order imposed by the event queues I was thinking of storing a simp

Re: Vulnerability PostgreSQL 11.2

2021-04-18 Thread Laurenz Albe
On Fri, 2021-04-16 at 10:57 -0700, Moris Rumenov Vrachovski wrote: > Thank you Laurenz! I have a second question. I downloaded postgreSQl 11.11 to > upgrade from 11.2. > I am having trouble upgrading postgresql, it is trying to install a new > postgreSQL instead of upgrading. That sounds right

Planning time grows exponentially with levels of nested views

2021-04-18 Thread Joel Jacobson
Hi, I assumed the cost for each nested VIEW layer would grow linear, but my testing shows it appears to grow exponentially: CREATE TABLE foo (bar int); INSERT INTO foo (bar) VALUES (123); DO $_$ DECLARE BEGIN CREATE OR REPLACE VIEW v1 AS SELECT * FROM foo; FOR i IN 1..256 LOOP EXECUTE format