]> git.bitcoin.ninja Git - rapid-gossip-sync-server/commit
projects / rapid-gossip-sync-server / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: fe8ccaf) | patch
Add one additional index which postgres prefers as the DB fills
authorMatt Corallo <git@bluematt.me>
Wed, 14 Sep 2022 20:12:17 +0000 (20:12 +0000)
committerMatt Corallo <git@bluematt.me>
Wed, 14 Sep 2022 20:18:30 +0000 (20:18 +0000)
commit0ca93841c0f442bd50e9ccd18a0a6d866cb3adf5
tree16d4759f44fa68492478a493592eeb5069629799tree | snapshot
parentfe8ccaffbdeb235b054a975706a7e70b667cf181commit | diff
Add one additional index which postgres prefers as the DB fills

If postgres decides walking the full `channel_updates_scid_dir_seen`
index and removing old `seen` values is slower than just walking
the full table (or this new index) it does so. Sadly this causes
re-sorting (usually on-disk), but there doesn't seem to be a way to
avoid this.
src/config.rs diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.