/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 yoshinorimatsunobu.blogspot.com
Yoshinori Matsunobu's blog: Making full table scan 10x faster in InnoDB
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
6.3 parsecs away

Travel
| | The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....
| | smalldatum.blogspot.com
Small Datum: The benefit of lz4 and zstd for Postgres WAL compression
7.6 parsecs away

Travel
| | In 2020 I published benchmark results to understand the impact of DBMS tuning options for the insert benchmark with MySQL and Postgres ( her...
| | afatkulin.blogspot.com
Alex Fatkulin's Blog: 11G adaptive direct path reads - what is the cached/dirty blocks threshold?
6.6 parsecs away

Travel
| | 11G's ability to do direct path reads during full table scans without utilizing PQ was covered in a number of places already (see this post ...
| | managementfromscratch.wordpress.com
Introduction to Gossip - Just my thoughts
38.5 parsecs away

Travel
| [update: you can see an implementation here ] Index Introduction Strengths of Gossip Applications Examples How do they work? A bit of history State of the nodes Analyzed algorithms Types of Gossip Removed state Modelling Rumour Mongering Strategies for spreading the gossip Strategies vs Models How to measure good epidemics The peer sampling service Caveats...