cardano-db-sync

cardano-db-sync copied to clipboard

Index Atala PRISM metadata...

2

Atala PRISM DID actions are encoded as protocol buffers on the Cardano blockchain. Because of this they are not indexed by any of the current indexers. It would be nice...

mgajda

Investigate using BRIN indexes

4

BRIN are a special case of postgres indexes https://www.postgresql.org/docs/current/brin-intro.html. They seem to better fit the workload of db-sync ``` BRIN is designed for handling very large tables in which certain...

kderme

Probably just a leftover or a typo.

mmahut

Redundant indexes already done by uniques constraints

3

Some indexes are not necessary because already part of composite indexes : - `idx_tx_out_tx_id ON tx_out(tx_id)` already done by `TABLE "tx_out" ADD CONSTRAINT "unique_txout" UNIQUE("tx_id","index")` - `idx_tx_in_tx_out_id ON tx_in(tx_out_id)` already...

jbgi

Improve error message when db-sync shuts down becasue the node tip is behind db-sync

2

This is something that can be often overlooked but when restoring state for `db-sync` from snapshot and starting service - if `cardano-node` tip is behind `db-sync `this will result in...

ArturWieczorek

Links to binaries in release page no longer work

1

All urls pointing to [https://hydra.iohk.io/](https://hydra.iohk.io/) do not work anymore

vokracko

Improve docker documentation

2

### Business Hypothesis The documentation needs to explain Docker and k8s use. Draft document: https://docs.google.com/document/d/1L-S1Avu5eUhMl8tg-tHuTMySY_jCibWUXlkgI_27ytQ/edit ### Drivers -Provide clear documentation for Docker use. ### Functional Requirements - [ ] Operational...

ArturWieczorek

Insert in Parallel

3

Currently all db insertions are done by a single thread. We could try and use more. We have to be careful about shared resources - Different threads should use different...

kderme

[SPIKE] - Assess UTxO HD impact on DBSync & Make Compatibility Changes

2

### Business Hypothesis We need to determine whether the UTxO HD implementation will impact DB-Sync. After discussion with Consensus team on 11/1/2022, it is likely that DBSync needs to change...

marshada

Inserting many entries together is faster than inserting one by one. This is especially apparent in snapshot restoration, where psql inserts whole tables in a single command very fast. db-sync...

kderme