About

More than 17 years of experience with various DBMSes, more than 13 years with PostgreSQL. M.S., MIPT and ISP RAS, specialty "Database systems".

Founder of Postgres.ai.

Founder of #RuPostgres (PostgreSQL user group for Russian-speaking users, the second in size on Meetup.com, 2000+ members).

Committee Chair for Database/Architecture Sections of Highload++, RITFest, and PGDay Russia.

Russian press contact at PostgreSQL Global Development Group.

Twitter: @postgresmen

---

Nikolay Samokhvalov has presented the following presentations

What is the optimal value of shared_buffers for your database? A use case of data-driven optimization based on database experiments at Postgres Conference

presented by Nikolay Samokhvalov
SLIDES: https://docs.google.com/presentation/d/1jinPA8Y5K_H8iKngG-Utpg1d8mOOVD7J3KQhX53z4XY/
What is the optimal value of shared_buffers for your database and workload? 8 GiB? Or 16? Is it worth using 70% of RAM if you run Postgres 11 on a server with 512 GiB of memory?
Of course, you might check dozen...
more
Thu 21 2019 Use Cases
Automated health checks of PostgreSQL clusters at Postgres Conference

presented by Nikolay Samokhvalov
SLIDES: https://docs.google.com/presentation/d/1ZkWboJqzug4q3UYajFdmXOtqyipcuhcQdL4g27GjKeg/edit?usp=sharing
To maintain a Postgres database in a healthy state, it needs periodical comprehensive diagnostics. Being done manually, it might take 1-2 weeks or more, especially if you are seeing...
more
Wed 20 2019 Ops and Administration
The Art of Database Experiments at Silicon Valley

presented by Nikolay Samokhvalov
Future database administration will be highly automated. Until then, we still live in a world where extensive manual interactions are required from a skilled DBA. This will change soon as more "autonomous databases" reach maturity and enter the production environment.
Postgres-specific monitoring tools and systems continue to improve, detecting and analyzing performance issues and bottleneck...
more
Tue 16 2018 Ops
Automated DBA at PostgresConf US 2018

presented by Nikolay Samokhvalov
postgres_dba is a brand new open source DBA toolset, that helps application developers and system engineers to find database issues and resolve them faster and easier.
Considering PostgreSQL (including its managed cloud versions like Heroku Postgres or AWS RDS Postgres), we'll discuss:
• why it is so important to have proper tools to analyze dat...
more
Operations and Administration