v1rusw0rm v1rusw0rm
v1rusw0rm
/ calltest.cs
Created
March 24, 2017 15:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public class CallTest | |
| { | |
| private Reference _ref; | |
| private Value _val; | |
| private INop _interfaceRef; | |
| private INop _interfaceVal; | |
| public CallTest() | |
| { | |
| _ref = new Reference(); |
v1rusw0rm
/ ienumerable_benchmarks.cs
Created
March 24, 2017 14:04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public class EnumeratingIEnumerables | |
| { | |
| private const int IdsCount = 1000; | |
| private readonly List<int> _ids; | |
| private readonly int[] _idsArray; | |
| public EnumeratingIEnumerables() | |
| { | |
| _ids = new List<int>(); | |
| _idsArray = new int[IdsCount]; |
v1rusw0rm
/ pg_index_cache_hit_rate.sql
Created
September 26, 2016 13:09
— forked from mattsoldo/pg_index_cache_hit_rate.sql
Postgres Index Hit Rate and Cache Hit Rate
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Index hit rate | |
| WITH idx_hit_rate as ( | |
| SELECT | |
| relname as table_name, | |
| n_live_tup, | |
| round(100.0 * idx_scan / (seq_scan + idx_scan),2) as idx_hit_rate | |
| FROM pg_stat_user_tables | |
| ORDER BY n_live_tup DESC | |
| ), |