|
|
CREATE EXTENSION dhoom_index_new; Instead of standard SQL, use the new syntax:
In the stock market, a 2-millisecond delay can mean a loss of millions. HFT firms are implementing Dhoom Index New on their order books to index buy/sell limits in real-time. The "New" algorithm reduces the index look-up time for outstanding orders by 40% compared to the previous generation. dhoom index new
| Metric | B-Tree Index | Dhoom Index (v2) | | | :--- | :--- | :--- | :--- | | Point Select (per sec) | 150,000 | 310,000 | 850,000 | | Insert (per sec) | 45,000 | 120,000 | 450,000 | | Index Size (MB) | 12,000 | 8,500 | 4,200 (50% compression) | | Fragmentation after 1hr | 23% | 8% | 0.5% | | Metric | B-Tree Index | Dhoom Index
When you have 1 million sensors sending data every second, traditional indexes collapse under the insert rate. Dhoom Index New handles insert rates of 5 million rows per second on commodity hardware because it never needs to reorganize the index. 000 | 310
| Â |