mirror of
https://github.com/lightningnetwork/lnd.git
synced 2026-08-20 13:27:27 +02:00
561edf8c96
Split GetNodesByLastUpdateRange into two query variants: one for all nodes and a new GetPublicNodesByLastUpdateRange for public-only nodes. The public-only variant uses two separate EXISTS checks (one per node_id column) instead of a single OR, allowing the planner to do direct index probes on each channel node-id index. Also upgrade the channel node-id indexes from single-column (node_id_1) and (node_id_2) to composite (node_id_1, version) and (node_id_2, version) to support version-aware public node checks while preserving usefulness for node-centric lookups.
31 lines
No EOL
1.3 KiB
SQL
31 lines
No EOL
1.3 KiB
SQL
-- Drop v2 block-height indexes.
|
|
DROP INDEX IF EXISTS graph_node_block_height_idx;
|
|
DROP INDEX IF EXISTS graph_channel_policy_block_height_idx;
|
|
|
|
-- Restore the original single-column last_update index.
|
|
DROP INDEX IF EXISTS graph_node_last_update_idx;
|
|
CREATE INDEX IF NOT EXISTS graph_node_last_update_idx ON graph_nodes(last_update);
|
|
|
|
-- Restore the original single-column channel node-id indexes.
|
|
DROP INDEX IF EXISTS graph_channels_node_id_1_idx;
|
|
DROP INDEX IF EXISTS graph_channels_node_id_2_idx;
|
|
CREATE INDEX IF NOT EXISTS graph_channels_node_id_1_idx ON graph_channels(node_id_1);
|
|
CREATE INDEX IF NOT EXISTS graph_channels_node_id_2_idx ON graph_channels(node_id_2);
|
|
|
|
-- Remove the block_height column from graph_nodes
|
|
ALTER TABLE graph_nodes DROP COLUMN block_height;
|
|
|
|
-- Remove the signature column from graph_channels
|
|
ALTER TABLE graph_channels DROP COLUMN signature;
|
|
|
|
-- Remove the funding_pk_script column from graph_channels
|
|
ALTER TABLE graph_channels DROP COLUMN funding_pk_script;
|
|
|
|
-- Remove the merkle_root_hash column from graph_channels
|
|
ALTER TABLE graph_channels DROP COLUMN merkle_root_hash;
|
|
|
|
-- Remove the block_height column from graph_channel_policies
|
|
ALTER TABLE graph_channel_policies DROP COLUMN block_height;
|
|
|
|
-- Remove the disable_flags column from graph_channel_policies
|
|
ALTER TABLE graph_channel_policies DROP COLUMN disable_flags; |