jonathangenlambda

Would it be possible to add functionality to combine two `TransactionWitnessSet`?

Running into the very same issue, on our private testnet, db-sync is fully stabilised (not much to stabilise anyways, due to easy and fast restarting on our private testnet).

@GBBx thank you so much for your comment - adding `cardano-graphql-background` fixed the issue!

Added to the same compose file, now running into different issue: ``` {"name":"cardano-graphql","hostname":"6f2c6a0b526e","pid":1,"level":50,"err":{"errno":-111,"code":"ECONNREFUSED","syscall":"connect","address":"172.18.0.6","port":5432},"msg":"connect ECONNREFUSED 172.18.0.6:5432","time":"2022-07-11T11:16:43.877Z","v":0} {"name":"cardano-graphql","hostname":"6f2c6a0b526e","pid":1,"level":40,"module":"Db","msg":"pgSubscriber: Reconnecting attempt 1","time":"2022-07-11T11:16:43.879Z","v":0} {"name":"cardano-graphql","hostname":"6f2c6a0b526e","pid":1,"level":40,"module":"Db","msg":"pgSubscriber: Reconnecting attempt 2","time":"2022-07-11T11:16:44.417Z","v":0} {"name":"cardano-graphql","hostname":"6f2c6a0b526e","pid":1,"level":40,"module":"Db","msg":"pgSubscriber: Reconnecting attempt 3","time":"2022-07-11T11:16:44.919Z","v":0} {"name":"cardano-graphql","hostname":"6f2c6a0b526e","pid":1,"level":20,"module":"Db","msg":"pgSubscriber: Connected","time":"2022-07-11T11:16:44.963Z","v":0} {"name":"cardano-graphql","hostname":"6f2c6a0b526e","pid":1,"level":30,"module":"Server","msg":"Initializing","time":"2022-07-11T11:16:44.963Z","v":0}...

It seems that graphql just "gives up" after Attempt 17 of 101, instead of keep trying. The solution was to really start hasura and graphql "later", that is after the...

For comparison: we saw "query utxos by txins" with 90+ txins taking only around 100 milliseconds. So regarding "query utxos by address" there is definitely something off there, and needs...

@carbolymer so do I understand this correctly: the queries will be even slower but consistently slower? This is unacceptable and makes it completely useless in any serious production setting.

> May I be wrong, but that query is not expected to be performant, nor it is expected to be used in production. Then put some warnings/documentation into haddock to...

Ogmios is just a REST wrapper around the cardano-node, there is no reason why it should be faster against your own local node. Besides that, it requires additional integration effort.

Ok we just had three extreme outlier cases where querying the address `addr1z92l7rnra7sxjn5qv5fzc4fwsrrm29mgkleqj9a0y46j5lqy7t0mecfnwgpzh0uh4vcqmd8du5yspdtgf0lllh27c5zshyv38p` took staggering 2 minutes and 35 seconds (!!). According to our grafana dashboard, the node had a...