Response time vs new database connection

Response time vs new database connection

This screenshot of some metric data in CloudWatch that clearly shows a link between response time spikes and changes in the glx.hibernate.connections.obtained custom metric. This is really interesting because it suggests that the connection pool is the bottleneck where requests start to get queued up.

Playing around with Datomic On-Prem and Postgres storage

Datomic On-Prem and Postgres storage

(require '[datomic.api :as d])
(def uri "datomic:sql://hello?jdbc:postgresql://localhost:5432/datomic?user=datomic&password=asdf")
(d/create-database uri)
(def conn (d/connect uri))

One problem on Windows: -cp *;lib/* to avoid line too long problem

http://gigasquidsoftware.com/blog/2015/08/15/conversations-with-datomic/

Transactor(s) and Peer(s) all talk to Postgres directly but the Peers also talk to the Transactor using HornetQ.

 

Peeking inside Postgres storage for Datomic on prem database 20191016.PNG