Changes between Version 4 and Version 5 of OtherTopics


Ignore:
Timestamp:
07/08/26 21:22:15 (4 days ago)
Author:
231118
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • OtherTopics

    v4 v5  
    1919[[Image(ss1_before.png)]]
    2020
    21 * '''After Index Creation:'''
    22   * Plan Output: `Index Scan` processing nodes filtering via the composite predicate.
     21* '''After Index Creation (Optimized Time-Window Filter):'''
     22  * Plan Output: `Bitmap Index Scan using idx_nc_timestamp_comp on network_connections nc`.
    2323  * Execution Time: 3.271 ms
    2424[[Image(ss1_after.2.png)]]
    2525
    2626* '''Index Usage Verification:''' Yes, the PostgreSQL engine bypassed raw relational sequential evaluation and bound query execution directly via index nodes inside the initial windowed CTE materialization.
    27 * '''Conclusion:''' Performance gains lowered overall query evaluation overhead, drastically reducing execution processing latency.
     27* '''Conclusion:''' Performance scaled by over '''82%''', successfully shifting execution path to targeted bitmap index scans.
    2828
    2929---