corpus.blog
41554 blogs · [ { "id": "01a08776-c45b-7048-ae16-8821d64e0fde", "title": "On visibility map and failing transactions", "url": "https://fadaiganjaliyev.com/on-visibility-map-and-failing-transactions/", "published_at": "2026-05-14T10:58:15+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821d7464772", "title": "Beyond Basic OS Tools", "url": "https://fadaiganjaliyev.com/beyond-basic-os-tools/", "published_at": "2025-06-14T10:05:00+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821d80e5477", "title": "Application-oblivious diagnosis", "url": "https://fadaiganjaliyev.com/application-agnostic-diagnosis/", "published_at": "2024-05-18T16:45:17+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821d8cab73d", "title": "Diving deeper into the LWLock in PostgreSQL.", "url": "https://fadaiganjaliyev.com/diving-deeper-into-the-lwlock-in-postgresql/", "published_at": "2023-11-23T16:11:44+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821d9a91dbf", "title": "Reasoning about OS Scheduler for Performance Degradation Analysis", "url": "https://fadaiganjaliyev.com/os-scheduler-analysis/", "published_at": "2023-03-03T07:21:23+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821d9f8102e", "title": "Six Ways to Force “Sequential Scan” in PostgreSQL", "url": "https://fadaiganjaliyev.com/six-ways-to-force-sequential-scan-in-postgres/", "published_at": "2023-01-10T10:07:35+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821da66170a", "title": "Parallel Query and %logons% Statistics", "url": "https://fadaiganjaliyev.com/parallel-query-and-logons-cumulative-statistics/", "published_at": "2022-11-28T10:58:22+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821da89a4e5", "title": "Implicit Population of Materialized Views in In-Memory Column Store", "url": "https://fadaiganjaliyev.com/an-implicit-population-of-materialized-views-in-inmemory/", "published_at": "2022-09-25T12:18:41+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821db39262f", "title": "Parallel Query and V$SQL", "url": "https://fadaiganjaliyev.com/parallel-query-and-vsql/", "published_at": "2022-09-21T08:05:51+00:00" }, { "id": "01a08776-c45b-7048-ae16-8821db482490", "title": "A potential method for determining the join method without explain plan", "url": "https://fadaiganjaliyev.com/method-for-determining-the-join-method/", "published_at": "2022-07-10T19:45:59+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf6ea9e0cb", "title": "The Hidden “INDEX UNIQUE SCAN”", "url": "https://fadaiganjaliyev.com/3362-2/", "published_at": "2022-06-21T13:10:04+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf6f1e5df5", "title": "The “force merge” process marks indexes searchable in Elasticsearch", "url": "https://fadaiganjaliyev.com/the-force-merge-process-marks-indexes-searchable-in-elasticsearch/", "published_at": "2022-05-06T18:48:00+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf6f98bb7a", "title": "Deciphering PostgreSQL process swap space utilization", "url": "https://fadaiganjaliyev.com/deciphering-postgresql-process-swap-space-utilization/", "published_at": "2022-03-27T19:21:00+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf6fff42d6", "title": "“Latch: row cache objects” wait event is gone in Oracle 21c", "url": "https://fadaiganjaliyev.com/latch-row-cache-objects-wait-event-is-gone-in-oracle-21c/", "published_at": "2022-03-21T07:43:00+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf7058ab44", "title": "Result Cache Malfunction in Oracle 21c", "url": "https://fadaiganjaliyev.com/result-cache-malfunction-in-oracle-21c/", "published_at": "2022-02-26T14:08:05+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf7091477f", "title": "FILLFACTOR parameter in PostgreSQL (Part II – source code hacking)", "url": "https://fadaiganjaliyev.com/fillfactor-parameter-in-postgresql-part-ii-source-code-hacking/", "published_at": "2022-02-18T10:47:45+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf71574d36", "title": "FILLFACTOR parameter in PostgreSQL (Part I)", "url": "https://fadaiganjaliyev.com/fillfactor-in-postgresql/", "published_at": "2022-02-12T21:12:55+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf7251bddb", "title": "On Node Addition in Apache Cassandra", "url": "https://fadaiganjaliyev.com/on-node-addition-in-apache-cassandra-ii/", "published_at": "2022-02-10T16:33:08+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf7350e43e", "title": "In Favor of Temporary Tablespaces", "url": "https://fadaiganjaliyev.com/in-favor-of-temporary-tablespaces-2/", "published_at": "2021-04-07T18:18:13+00:00" }, { "id": "01a0c50c-5c2f-7018-8eb5-e2cf7416de6d", "title": "The World’s Shortest Troubleshooting Scenario", "url": "https://fadaiganjaliyev.com/the-worlds-shortest-troubleshooting-scenario-2/", "published_at": "2021-02-06T18:16:47+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd91e47157", "title": "Tunable PGA analogue in Hadoop", "url": "https://fadaiganjaliyev.com/tunable-pga-analogue-in-hadoop/", "published_at": "2021-01-13T20:22:50+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd928e7a07", "title": "Troubleshooting Slowness Associated with Log Activity (again briefly)", "url": "https://fadaiganjaliyev.com/troubleshooting-slowness-associated-with-log-activity-again-briefly-2/", "published_at": "2021-01-06T18:14:38+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd92c621e2", "title": "Library cache: mutex X and another slowness scenario (briefly)", "url": "https://fadaiganjaliyev.com/library-cache-mutex-x-and-another-slowness-scenario-briefly-3/", "published_at": "2021-01-05T18:34:23+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd92f6402c", "title": "DBWR and the Shared Pool – Part II", "url": "https://fadaiganjaliyev.com/dbwr-and-the-shared-pool-part-ii%ef%bf%bc/", "published_at": "2020-07-22T17:59:51+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd936da7e1", "title": "On ORDER BY clause removal by the CBO", "url": "https://fadaiganjaliyev.com/on-order-by-clause-removal-by-the-cbo-2/", "published_at": "2020-06-25T18:03:55+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd945ed766", "title": "INDEX FULL SCAN and Sorting Avoidance", "url": "https://fadaiganjaliyev.com/index-full-scan-and-sorting-avoidance-2/", "published_at": "2020-06-03T18:12:11+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd94dfffb3", "title": "Feeding intelligence into synchronization primitives", "url": "https://fadaiganjaliyev.com/feeding-intelligence-into-synchronization-primitives/", "published_at": "2020-05-31T17:53:54+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd95bda772", "title": "DBWR and the Shared Pool", "url": "https://fadaiganjaliyev.com/dbw-and-the-shared-pool-2/", "published_at": "2019-12-13T18:31:22+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd9665a35c", "title": "Preempted Mutex Holders", "url": "https://fadaiganjaliyev.com/preempted-mutex-holders/", "published_at": "2019-04-16T18:29:45+00:00" }, { "id": "01a0c51b-b765-71a3-82e1-07cd9706c186", "title": "A New Paper on Spinlocks meeting Machine Learning", "url": "https://fadaiganjaliyev.com/a-new-paper-on-spinlocks-meeting-machine-learning/", "published_at": "2019-04-01T17:51:23+00:00" }, { "id": "01a0c526-d7e3-7132-b313-30d292bb836c", "title": "Intelligent Database Management Systems", "url": "https://fadaiganjaliyev.com/2918-2/", "published_at": "2019-01-26T18:50:31+00:00" }, { "id": "01a0c526-d7e3-7132-b313-30d29322f36c", "title": "Latching and Result Cache – A Quick Troubleshooting Case", "url": "https://fadaiganjaliyev.com/latching-and-result-cache-a-quick-troubleshooting-case-2/", "published_at": "2019-01-09T18:22:12+00:00" } ] posts Claim your blog
Back to fadaiganjaliyev.com
Blog · corpus.blog/blogs/fadaiganjaliyev.com/posts

fadaiganjaliyev.com

fadaiganjaliyev.com

2026

On visibility map and failing transactionsoriginal ↗
14 May 2026

2025

Beyond Basic OS Toolsoriginal ↗
14 Jun 2025

2024

Application-oblivious diagnosisoriginal ↗
18 May 2024

2023

Diving deeper into the LWLock in PostgreSQL.original ↗
23 Nov 2023
Reasoning about OS Scheduler for Performance Degradation Analysisoriginal ↗
3 Mar 2023
Six Ways to Force “Sequential Scan” in PostgreSQLoriginal ↗
10 Jan 2023

2022

Parallel Query and %logons% Statisticsoriginal ↗
28 Nov 2022
Implicit Population of Materialized Views in In-Memory Column Storeoriginal ↗
25 Sept 2022
Parallel Query and V$SQLoriginal ↗
21 Sept 2022
A potential method for determining the join method without explain planoriginal ↗
10 Jul 2022
The Hidden “INDEX UNIQUE SCAN”original ↗
21 Jun 2022
The “force merge” process marks indexes searchable in Elasticsearchoriginal ↗
6 May 2022
Deciphering PostgreSQL process swap space utilizationoriginal ↗
27 Mar 2022
“Latch: row cache objects” wait event is gone in Oracle 21coriginal ↗
21 Mar 2022
Result Cache Malfunction in Oracle 21coriginal ↗
26 Feb 2022
FILLFACTOR parameter in PostgreSQL (Part II – source code hacking)original ↗
18 Feb 2022
FILLFACTOR parameter in PostgreSQL (Part I)original ↗
12 Feb 2022
On Node Addition in Apache Cassandraoriginal ↗
10 Feb 2022

2021

In Favor of Temporary Tablespacesoriginal ↗
7 Apr 2021
The World’s Shortest Troubleshooting Scenariooriginal ↗
6 Feb 2021
Tunable PGA analogue in Hadooporiginal ↗
13 Jan 2021
Troubleshooting Slowness Associated with Log Activity (again briefly)original ↗
6 Jan 2021
Library cache: mutex X and another slowness scenario (briefly)original ↗
5 Jan 2021

2020

DBWR and the Shared Pool – Part IIoriginal ↗
22 Jul 2020
On ORDER BY clause removal by the CBOoriginal ↗
25 Jun 2020
INDEX FULL SCAN and Sorting Avoidanceoriginal ↗
3 Jun 2020
Feeding intelligence into synchronization primitivesoriginal ↗
31 May 2020

2019

DBWR and the Shared Pooloriginal ↗
13 Dec 2019
Preempted Mutex Holdersoriginal ↗
16 Apr 2019
A New Paper on Spinlocks meeting Machine Learningoriginal ↗
1 Apr 2019
Intelligent Database Management Systemsoriginal ↗
26 Jan 2019
Latching and Result Cache – A Quick Troubleshooting Caseoriginal ↗
9 Jan 2019