andrew on Nostr: This one is just block headers from the LevelDB index. Takes literally seconds to ...
This one is just block headers from the LevelDB index. Takes literally seconds to dump from a running bitcoin-core and import into PostgreSQL.
Looking how to get the block content into Pg in the most efficient fashion possible. I’m frankly disgusted at tools that take 2x storage, tons of RAM and days of calendar time.
Published at
2023-01-03 12:51:03Event JSON
{
"id": "402b10b5298dbae84224d4ef58c86a35ad4a1ef9e69e7c2159272f61791ca390",
"pubkey": "b726de20b515705ffee951591e8f54f42f93bb8509df81a851cd5bc949ec1332",
"created_at": 1672750263,
"kind": 1,
"tags": [
[
"e",
"30870702661f4b8094d61d695dddfacd82cc3b9d9ff4d9a456ffb85e8898bbca"
],
[
"e",
"44a410eddcd79e042e1f18fcc3f9ad0151260c4cfcab4bd22a97e5632bb34932"
],
[
"p",
"2590201e2919a8aa6568c88900192aa54ef00e6c0974a5b0432f52614a841ec8"
]
],
"content": "This one is just block headers from the LevelDB index. Takes literally seconds to dump from a running bitcoin-core and import into PostgreSQL.\n\nLooking how to get the block content into Pg in the most efficient fashion possible. I’m frankly disgusted at tools that take 2x storage, tons of RAM and days of calendar time.",
"sig": "08dd944fc1fbce81706674829ddb78a03589dc50ff8ae484cdf79ca594dd642cf001a3991ba4cc7b4be019e16af73753399fcaa2d5d40fb3b3c6eee7cff87642"
}
