Nikolay Samokhvalov
San Diego, California, United States
7K followers
500+ connections
About
My current primary interests are:
- experiment-centric database administration…
Services
Articles by Nikolay
Activity
Experience
Education
-
Moscow Institute of Physics and Technology (State University) (MIPT)
-
-
Key interests: documented-oriented scalable storages, XML type for RDBMS, relational vs non-relational, XML indexing, extensions to relational data model.
XML type development for PostgreSQL (committed to the core and released, see Changelog for PostgreSQL 8.3) -
-
-
Licenses & Certifications
-
EDB PostgreSQL 9.6 Associate Certification (was curious and paid $200 for silly questions like "what is the title of pgAdmin window that provides advice?" - "Guru Hint", Google said. It was fun though)
EnterpriseDB
IssuedCredential ID DGJD7D68GH/EDB91614 -
Molchanovs Freediver Certificate - Wave 4 (AIDA 4* compatible)
Molchanovs
IssuedCredential ID 001452
Publications
-
Three Cases Against IF NOT EXISTS / IF EXISTS in Postgres DDL
See publicationIf we aim to have predictable results, it is better to avoid IF NOT EXISTS / IF EXISTS in DB schema migrations.
-
How partial, covering, and multicolumn indexes may slow down UPDATEs in PostgreSQL
See publication"Primum non nocere" – this is a fundamental principle that is well-known to anyone working in healthcare: "first, do no harm". Do we need to follow this principle when optimizing SQL queries?
-
Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues)
See publicationPostgreSQL locking issues may be annoying. This blog post provides useful information that will help you understand how PostgreSQL MVCC implements locking and how to troubleshoot locking issues.
-
Zero-downtime Postgres schema migrations need this: lock_timeout and retries
See publicationDeploying DB schema changes in heavily loaded systems is challenging. In this article, we explore one of the challenges - how to avoid situations when DDLs get blocked, wait to acquire a lock, and during that, start blocking other sessions.
-
What is a slow SQL query?
See publicationIs 200 ms slow for an SQL query? What about 20 ms? When do we need to optimize?
-
PostgreSQL Subtransactions Considered Harmful
See publicationAn opinionated overview of four cases against using PostgreSQL subtransactions
-
PostgreSQL 8.3
Postgresmen
See publicationWhats new in Postgres 8.3 (in Russian)
see also comments at http://habrahabr.ru/post/14933/ -
Comprehensive Metadata Query Interface for Heterogeneous Data Archives Based on Open-Source PostgreSQL ORDBMS
Astronomical Data Analysis Software and Systems XVI ASP Conference Series, Vol. 376, proceedings of the conference held 15-18 October 2006 in Tucson, Arizona, USA
We use the PostgreSQL DBMS for storing XML metadata, described by the IVOA Characterization Data Model. Initial XML type support in PostgreSQL has recently been implemented. We make heavy use of this feature in order to provide a comprehensive search capability over the Characterisation metadata tree. We built a prototype of the Characterization metadata query service, implementing two access methods: (1) HTTP-GET/POST based interface, which implements almost direct translation of the query…
We use the PostgreSQL DBMS for storing XML metadata, described by the IVOA Characterization Data Model. Initial XML type support in PostgreSQL has recently been implemented. We make heavy use of this feature in order to provide a comprehensive search capability over the Characterisation metadata tree. We built a prototype of the Characterization metadata query service, implementing two access methods: (1) HTTP-GET/POST based interface, which implements almost direct translation of the query parameter name into XPath of the data model element in the XML serialization; (2) Web-Service based interface to receive XQuery which is also directly translated into XPath. This service will be used in the ASPID-SR archive, containing science-ready data obtained with the Russian 6-m telescope.
Other authorsSee publication
Courses
-
"Deep Dive" entrepreneur program in Silicon Valley
-
-
Mining Massive Datasets (Stanford University)
-
-
Philosophy
-
Projects
Test Scores
-
Mining Massive Datasets (online course, Stanford University)
Score: 4.82
Successfully completed online course Mining Massive Datasets with Distinction.
This course covers "big-data" algorithms, including locality-sensitive
hashing, PageRank, stream algorithms, clustering, social-network graph
analysis, large-scale machine learning, recommendation systems,
computational advertising, and dimensionality reduction. The SoA with
Distinction is awarded to those scoring at least 80% of the marks, half
based on homeworks and half on a timed final…Successfully completed online course Mining Massive Datasets with Distinction.
This course covers "big-data" algorithms, including locality-sensitive
hashing, PageRank, stream algorithms, clustering, social-network graph
analysis, large-scale machine learning, recommendation systems,
computational advertising, and dimensionality reduction. The SoA with
Distinction is awarded to those scoring at least 80% of the marks, half
based on homeworks and half on a timed final exam.
Authenticity can be verified at https://verify.lagunita.stanford.edu/SOA/ea7221e322b5416fbbc2414618f78771
Languages
-
English
Full professional proficiency
-
Russian
Native or bilingual proficiency
Recommendations received
5 people have recommended Nikolay
Join now to viewMore activity by Nikolay
-
I've been working with relational databases for years now. In the early days, they seemed like an almost magical technology, capable of taking…
I've been working with relational databases for years now. In the early days, they seemed like an almost magical technology, capable of taking…
Liked by Nikolay Samokhvalov
-
Postgres hacking session live now: https://lnkd.in/gvQVPtf6
Postgres hacking session live now: https://lnkd.in/gvQVPtf6
Posted by Nikolay Samokhvalov
-
"postgres pathology" -- what are the first things that come to your mind?
"postgres pathology" -- what are the first things that come to your mind?
Posted by Nikolay Samokhvalov
-
The thing I've been working on the past few months is finally released: Having MotherDuck speak the Postgres protocol! There's still a long road…
The thing I've been working on the past few months is finally released: Having MotherDuck speak the Postgres protocol! There's still a long road…
Liked by Nikolay Samokhvalov
-
Just watched a Postgres talk in Portuguese (Brazil) not knowing the language The new feature in Google Translate for live translation is what I…
Just watched a Postgres talk in Portuguese (Brazil) not knowing the language The new feature in Google Translate for live translation is what I…
Posted by Nikolay Samokhvalov
-
Last year, Google Summer of Code received 15,240 applicants from 130 countries submitting 23,559 proposals. Only 1,272 contributors from 68 countries…
Last year, Google Summer of Code received 15,240 applicants from 130 countries submitting 23,559 proposals. Only 1,272 contributors from 68 countries…
Liked by Nikolay Samokhvalov
Other similar profiles
Explore top content on LinkedIn
Find curated posts and insights for relevant topics all in one place.
View top content