[bug]: Graph builder takes 30+ minutes with postgres backend #10321
Description
Pre-Submission Checklist
- I have searched the existing issues and believe this is a new bug.
- I am not asking a question about how to use lnd, but reporting a bug (otherwise open a discussion).
LND Version
0.20.0-beta.rc1
LND Configuration
[db]
db.no-rev-log-amt-data=true
db.backend=postgres
db.postgres.dsn=postgres://db.postgres.timeout=360s
db.use-native-sql=true
db.postgres.maxconnections=50
Backend Version
Bitcoin Core version v28.0
Backend Configuration
N/A
OS/Distribution
Ubuntu 24.04.3 LTS
Bug Details & Steps to Reproduce
On starting LND, it takes 30-45 minutes for LND to become healthy (after wallet password is input). The backend is using postgres and was migrated on v19.3 from bbolt. Initially when I migrated, LND only took 10~ minutes to become healthy, and over the months the restart time has increased.
[INF] GRPH: Builder starting
Expected Behavior
Other users in PLEBNET have mentioned their LND takes minutes to become healthy when running on postgres and it seems my load times are unexpected.
Debug Information
No response
Environment
No response