Rafael Cárdenas 3a02f5741f fix: optimize mempool transaction reads and writes (#1781) ...

* fix: change mempool_digest into a table

* fix: change digest to be last updated timestamp

* fix: build

* fix: update count on reconcile

* test: mempool renconcile

2024-01-02 09:59:07 -06:00

..

1584604583726_blocks.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1584619633448_txs.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1588252682585_stx_events.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1588256295395_ft_events.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1588261750265_nft_events.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1588266401242_contract_logs.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1588266891631_smart_contracts.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1589552602432_faucet_requests.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1591291822107_mempool_txs.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1605100253938_stx_lock_events.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1605184662317_miner_rewards.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1605273328873_burnchain_rewards.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1608030374841_namespaces.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1608030374842_names.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1610030345948_subdomains.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1614862087968_reward_slot_holders.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1616752858364_config_state.js

feat: Stacks 2.1 support (#1498)

2022-12-23 15:49:57 +01:00

1618484818407_token_offering_locked.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1620731555813_event_observer_requests.js

feat: Stacks 2.1 support (#1498)

2022-12-23 15:49:57 +01:00

1620937804009_microblocks.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1621511823100_token_metadata_queue.js

feat: Stacks 2.1 support (#1498)

2022-12-23 15:49:57 +01:00

1621511823381_nft_metadata.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1621511832113_ft_metadata.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1626441820095_zonefiles.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1636130197558_nft_custody.js

feat: Stacks 2.1 support (#1498)

2022-12-23 15:49:57 +01:00

1640037852136_nft_custody_unanchored.js

feat: Stacks 2.1 support (#1498)

2022-12-23 15:49:57 +01:00

1640651533899_principal_stx_txs.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1643755236533_chain_tip.js

feat: Stacks 2.1 support (#1498)

2022-12-23 15:49:57 +01:00

1647573802137_mempool_digest.js

feat: Stacks 2.1 support (#1498)

2022-12-23 15:49:57 +01:00

1663701407339_subdomains_owner_index.js

feat: Stacks 2.1 support (#1498)

2022-12-23 15:49:57 +01:00

1666703991492_pox_events.js

fix: revert configurable DB index type

2023-09-19 10:58:39 +01:00

1673632140730_pox_state_fix.js

fix: use pg bigint for pox_v1_unlock_height column (#1521)

2023-01-13 20:38:08 +01:00

1673895089997_contract_logs_contract_identifier_index.js

chore: merge master into beta

2023-02-03 10:03:44 -06:00

1674838340313_contract_logs_block_height_index.js

chore: merge master into beta

2023-02-03 10:03:44 -06:00

1679508966141_namespace-discount-bigint.js

fix: expand namespace discount column types to numeric (#1591)

2023-03-22 12:39:48 -06:00

1682694573447_pox_2_unlock.js

Merge branch 'master' into develop

2023-07-06 13:51:39 +02:00

1683284524000_pox_3_events.js

Merge branch 'master' into develop

2023-07-06 13:51:39 +02:00

1688650854502_pox_events_indexes.js

fix: add indexes to pox3_events table used for stacker lookup endpoints

2023-07-06 17:34:48 +02:00

1696872367486_nft-custody-tables.js

merge master into nakamoto (#1746)

2023-11-07 13:38:05 -06:00

1699540187362_remove-token-metadata.js

refactor: remove old token metadata processor (#1747)

2023-11-09 10:11:26 -06:00

1700071472495_chain-tip-table.js

fix: convert chain_tip materialized view into a table (#1751)

2023-11-16 13:34:18 -06:00

1701368149776_nakamoto-txs.js

feat: update to latest TenureChange tx payload (#1767)

2023-12-13 18:32:55 +01:00

1702134678728_pox_4_events.js

feat: pox-4 support (#1754)

2023-12-13 12:58:37 +01:00

1702913457527_block-tx-count.js

feat: add tx_count property to /extended/v2/blocks (#1778)

2023-12-19 10:02:02 -06:00

1703177555075_mempool-digest-table.js

fix: optimize mempool transaction reads and writes (#1781)

2024-01-02 09:59:07 -06:00