I haven't seen a case study swooning or anything about LND with postgres. I'm curious if it's better for a production use case with 10000x the "load" of a normal routing node or if it's merely more convenient than the embedded db devops wise.
11.2k sats \ 0 replies \ @aljaz 26 Sep
i'm assuming you're talking about the real postgres integration that LL is working on, not the KV joke. There is performance testing from alby from a year and a half ago for the KV one
i missed the latest LLabs roundtable but there are generally several problems to performance:
- external database adds network latency and round trips over boltdb
- you need very good architecture, schema and implementation due to row/table locking with updates etc
- if you have synchronous replication for high availability you inject more latency into the process
Generally I don't think you'd want to be the early adopter of this if you want a high performance node since i'd expect a mixed bag of results and issues before the database gets polished enough. I'm also not sure postgresql integration, if done with 1:1 mapping is ever gonna be as high performance as boltdb. But I have not kept up2date with latest developments and architecture changes in lnd to see how they envisioned this migration and getting the performance up for it.
reply
10 sats \ 2 replies \ @clarity 26 Sep
Didn’t know that existed.
Probably better all around, especially since you’re already running Postgres.
I’m thinking data analysis.
I don’t even know what the embedded db is for the LND, written in Golang.
I also don’t know how they shoved LND golang app into a phone with Zeus.
I also don’t know how to convince anybody to work on a project with me.
reply
30 sats \ 1 reply \ @DarthCoin 23h
I don't know why you comment if you don't know nothing.
reply
0 sats \ 0 replies \ @clarity 16h
Giving ideas on what all questions need answered in the wild Wild West.
reply
0 sats \ 0 replies \ @SwapMarket 21h
I will be coming in v0.19. Ziggie is working on it.
reply
0 sats \ 2 replies \ @Satosora 26 Sep
I think that is a @DarthCoin question.
reply
21 sats \ 1 reply \ @DarthCoin 23h
no, we already have the mighty LN chad here that answered to that specific technical question.
reply
0 sats \ 0 replies \ @Satosora 23h
You were a little late today.
reply