Replies: 2 comments 9 replies
-
|
Do you regularly compact your channel DB (e.g. use Also, turning on But to answer your question: You can follow along the progress to migrate to "native" SQL tables here: #6288 For new nodes there is also a way to use Postgres as a backend (but with the data still being in the key/value format, just stored in Postgres tables): https://github.com/lightningnetwork/lnd/blob/master/docs/postgres.md There are also plans to finally make progress on the data migration tool that would allow you to migrate your node over from bbolt to Postgres: lightninglabs/lndinit#21 |
Beta Was this translation helpful? Give feedback.
-
|
The auto compact feature is on. What does it mean to disable the free list sync, please? BTW, I usually restart every other week and it takes about an hour to start it up. |
Beta Was this translation helpful? Give feedback.
-
|
The free list sync is a feature of the What part takes that long? The compaction or opening the DB? You can see that in the logs. Is this on an SSD? |
Beta Was this translation helpful? Give feedback.
-
|
It is on an SSD disk... 2023-09-21 04:18:52.791 [INF] LTND: Active chain: Bitcoin (network=mainnet) |
Beta Was this translation helpful? Give feedback.
-
|
No, that is a one-time option that only does something the first time you use it. |
Beta Was this translation helpful? Give feedback.
-
|
So, I tried to prune the revocations but it is still 5.7GB and it took an hour to open the DB. Perhaps I should do the opposite and disable the compacting. |
Beta Was this translation helpful? Give feedback.
-
|
Do you have a lot of invoices or payments? Or channels with a lot of updates ( |
Beta Was this translation helpful? Give feedback.
-
|
I've got 100+ channels for about two years. Most of the channels have hundreds of thousands of num_updates. |
Beta Was this translation helpful? Give feedback.
-
|
Well, then one thing that you can do is close the channels with most updates and re-open them. Not very nice from a chain fee perspective but that will clean up a lot of state in the DB (will only be apparent after compacting though). |
Beta Was this translation helpful? Give feedback.
-
Hi there,
Is there a plan to speed up the Postgres migration feature? I've been running a hobby none for over two years now, and it somehow became a Top50 LN node. But now the node is becoming too slow mainly because of the channel DB. I can even hardly restart the node without a major outage.
Any idea?
Thank you,
Pavel
Beta Was this translation helpful? Give feedback.
All reactions