Nikolay Samokhvalov
Founder at Nombox / Postgres.ai
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
Upcoming presentations
No upcoming presentations...
Past presentations
- why it is so important to have proper tools to analyze dat...
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...
Mar 21 2019
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...
Mar 20 2019
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...
Oct 16 2018
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: