DEV Community

Dmitry Romanoff profile picture

Dmitry Romanoff

404 bio not found

Joined Joined on  github website
Python. Exploring MySQL Table Sizes.
dm8ry profile

Python. Exploring MySQL Table Sizes.

#mysql #python #monitoring #tutorial
Comments
1 min read

Want to connect with Dmitry Romanoff?

Create an account to connect with Dmitry Romanoff. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
How the presence of indexes and the size of tables affect the choice of execution plan when joining tables in PostgreSQL?
dm8ry profile

How the presence of indexes and the size of tables affect the choice of execution plan when joining tables in PostgreSQL?

#postgres #devops #database #performance
1
Comments
7 min read
Populating a table in PostgreSQL with one million records of random data.
dm8ry profile

Populating a table in PostgreSQL with one million records of random data.

#postgres #database #sql #tutorial
Comments
1 min read
The main methods of joining tables in PostgreSQL.
dm8ry profile

The main methods of joining tables in PostgreSQL.

#database #postgres #sql #tutorial
Comments
3 min read
The ARRAY_TO_STRING() function in PostgreSQL
dm8ry profile

The ARRAY_TO_STRING() function in PostgreSQL

#postgres #database #sql #tutorial
Comments
2 min read
How do you check a distribution of values that PostgreSQL has collected on some column of a table?
dm8ry profile

How do you check a distribution of values that PostgreSQL has collected on some column of a table?

#postgres #database #devops #tutorial
1
Comments
2 min read
Python code to know the zodiac sign based on the provided birthday.
dm8ry profile

Python code to know the zodiac sign based on the provided birthday.

#python #codenewbie #programming
Comments
2 min read
Python code that inserts a large number of records into a MySQL table.
dm8ry profile

Python code that inserts a large number of records into a MySQL table.

#mysql #python #database #postgres
Comments
2 min read
Python. Automating creation backups of MySQL database.
dm8ry profile

Python. Automating creation backups of MySQL database.

#python #mysql #devops #database
Comments
4 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?
dm8ry profile

How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

#postgres #database #sql #howto
3
Comments 1
2 min read
DevOps. Monitoring Databases. On-Premise and Cloud Environments.
dm8ry profile

DevOps. Monitoring Databases. On-Premise and Cloud Environments.

#monitoring #database #postgres #devops
1
Comments
1 min read
PostgreSQL: Deleting all records from a table, except for the first and last ones.
dm8ry profile

PostgreSQL: Deleting all records from a table, except for the first and last ones.

#postgres #database #sql #data
2
Comments
2 min read
How to find the third and fifth-highest values in a PostgreSQL table?
dm8ry profile

How to find the third and fifth-highest values in a PostgreSQL table?

#postgres #database #howto #sql
1
Comments
2 min read
Understanding of NULL in PostgreSQL database.
dm8ry profile

Understanding of NULL in PostgreSQL database.

#postgressql #database #sql #howto
3
Comments
2 min read
How to join tables in PostgreSQL using the WITH clause?
dm8ry profile

How to join tables in PostgreSQL using the WITH clause?

#postgres #database #sql #howto
1
Comments
2 min read
PostgreSQL. How to check connections that are not using SSL encryption?
dm8ry profile

PostgreSQL. How to check connections that are not using SSL encryption?

#security #database #postrges #devops
1
Comments
2 min read
Statistical information about tables in a PostgreSQL Database.
dm8ry profile

Statistical information about tables in a PostgreSQL Database.

#postgres #database #sql #devops
1
Comments
2 min read
About transaction identifier (transaction_id) in PostgreSQL.
dm8ry profile

About transaction identifier (transaction_id) in PostgreSQL.

#postgres #devops #database #sql
6
Comments
2 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?
dm8ry profile

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

#devops #database #postgres #howto
1
Comments
2 min read
How to check the distribution of timestamps in a PostgreSQL table?
dm8ry profile

How to check the distribution of timestamps in a PostgreSQL table?

#postgres #database #sql #devops
Comments
3 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?
dm8ry profile

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

#howto #postgres #sql #database
Comments
2 min read
Getting error when starting Rancher Desktop on Mac.
dm8ry profile

Getting error when starting Rancher Desktop on Mac.

#devops #docker #opensource #howto
Comments
1 min read
How to find the number of SELECTs, INSERTs, DELETEs, and UPDATEs on a specific table in PostgreSQL?
dm8ry profile

How to find the number of SELECTs, INSERTs, DELETEs, and UPDATEs on a specific table in PostgreSQL?

#database #tutorial #devops #postgressql
2
Comments
1 min read
How do you check the top IOPs intensive queries in PostgreSQL DB?
dm8ry profile

How do you check the top IOPs intensive queries in PostgreSQL DB?

#database #devops #sql #performance
Comments
2 min read
PostgreSQL. How do you find potentially ineffective indexes?
dm8ry profile

PostgreSQL. How do you find potentially ineffective indexes?

#database #postgres #sql #devops
Comments
2 min read
Unveiling Differences: A Deep Dive into Comparing Tables, Indexes, and Functions Across PostgreSQL Databases
dm8ry profile

Unveiling Differences: A Deep Dive into Comparing Tables, Indexes, and Functions Across PostgreSQL Databases

#database #postgres #sql #howto
Comments
7 min read
How to reset pg_stat_database statistics for all DBs on a PostgreSQL Server?
dm8ry profile

How to reset pg_stat_database statistics for all DBs on a PostgreSQL Server?

#postgres #database #devops #bash
3
Comments
2 min read
How to check the number of queries per second (QPS) on the PostgreSQL DB instance?
dm8ry profile

How to check the number of queries per second (QPS) on the PostgreSQL DB instance?

#postgres #database #sql #devops
7
Comments
1 min read
How to check the number of transactions per second (TPS) for the given PostgreSQL DB instance?
dm8ry profile

How to check the number of transactions per second (TPS) for the given PostgreSQL DB instance?

#postgres #devops #bash #database
2
Comments
2 min read
PostgreSQL: pg_stat_reset() is not resetting all statistics counters.
dm8ry profile

PostgreSQL: pg_stat_reset() is not resetting all statistics counters.

#postgres #devops #database
Comments
1 min read
How do you check temporary file generation for each PostgreSQL DB on the Server?
dm8ry profile

How do you check temporary file generation for each PostgreSQL DB on the Server?

#postgres #database #devops #sql
Comments
1 min read
PostgreSQL: script to connect to DB, and get tables, their records number and size.
dm8ry profile

PostgreSQL: script to connect to DB, and get tables, their records number and size.

#postgres #database #devops #bash
1
Comments 1
2 min read
MySQL: ERROR 1227 (42000) at line 27: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
dm8ry profile

MySQL: ERROR 1227 (42000) at line 27: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

#mysql #devops #database #howto
Comments
1 min read
Python: How to check telnet status?
dm8ry profile

Python: How to check telnet status?

#python #devops #programming #tutorial
Comments
1 min read
Postgres. How to check the top queries that use temporary files?
dm8ry profile

Postgres. How to check the top queries that use temporary files?

#postgres #sql #devops #performance
Comments
1 min read
PostgreSQL. How to list the most IOPs-intensive queries?
dm8ry profile

PostgreSQL. How to list the most IOPs-intensive queries?

#postgres #sql #database #devops
3
Comments
1 min read
Postgres: DB parameters configuration on the level of User / Database
dm8ry profile

Postgres: DB parameters configuration on the level of User / Database

#postgres #database #sql #devops
1
Comments
1 min read
Postgres Order By: the resultset is sorted differently
dm8ry profile

Postgres Order By: the resultset is sorted differently

#postgres #database #devops #sql
1
Comments
1 min read
PostgreSQL DB Server. The read-only user is able to create and own tables.
dm8ry profile

PostgreSQL DB Server. The read-only user is able to create and own tables.

#postgressql #database #devops #sql
1
Comments
2 min read
How to estimate the number of rows and size of tables in Postgres DB?
dm8ry profile

How to estimate the number of rows and size of tables in Postgres DB?

#devops #postgres #database
1
Comments
1 min read
How to limit the number of connections on the level of the DB user / Database in the Postgres Server?
dm8ry profile

How to limit the number of connections on the level of the DB user / Database in the Postgres Server?

#postgres #devops #tutorial #database
2
Comments
1 min read
ERROR: permission denied to create extension "pg_trgm". HINT: Must be part of the azure_pg_admin role to create this extension.
dm8ry profile

ERROR: permission denied to create extension "pg_trgm". HINT: Must be part of the azure_pg_admin role to create this extension.

#devops #postgres #database #performance
1
Comments
2 min read
How to know which DB objects caused a high DB storage growth rate?
dm8ry profile

How to know which DB objects caused a high DB storage growth rate?

#postgres #database #devops #tutorial
1
Comments
3 min read
How to check Postgres VACUUM process progress?
dm8ry profile

How to check Postgres VACUUM process progress?

#devops #database #sql #postgres
2
Comments
1 min read
Postgres. CREATE INDEX concurrently <index_name> ON <table_name> ... takes too long.
dm8ry profile

Postgres. CREATE INDEX concurrently <index_name> ON <table_name> ... takes too long.

#database #devops #postgres #sql
1
Comments
1 min read
How to list and set tags for AWS RDS using CLI?
dm8ry profile

How to list and set tags for AWS RDS using CLI?

#aws #cli #devops #database
Comments
1 min read
How to create read-only user in PostgreSQL DB?
dm8ry profile

How to create read-only user in PostgreSQL DB?

#postgres #database #devops #sql
1
Comments
1 min read
How to generate HTML report based on PostgreSQL queries?
dm8ry profile

How to generate HTML report based on PostgreSQL queries?

#python #postgres #html #database
2
Comments
1 min read
PostgreSQL DB Indexes Maintenance Script
dm8ry profile

PostgreSQL DB Indexes Maintenance Script

#devops #performance #postgres #bash
2
Comments
7 min read
PostgreSQL version 15+ ERROR: permission denied for schema public
dm8ry profile

PostgreSQL version 15+ ERROR: permission denied for schema public

#devops #database #postgressql #postgres
1
Comments
1 min read
Using PgBouncer to improve performance and reduce the load on PostgreSQL
dm8ry profile

Using PgBouncer to improve performance and reduce the load on PostgreSQL

#postgres #performance #database #devops
3
Comments
7 min read
How to parse Postgres log file and to print all the errors along with a specified number of lines before and after each error?
dm8ry profile

How to parse Postgres log file and to print all the errors along with a specified number of lines before and after each error?

#aws #devops #bash #postgres
Comments
1 min read
How to download AWS RDS Postgres log files?
dm8ry profile

How to download AWS RDS Postgres log files?

#postgres #aws #bash #postgressql
1
Comments
1 min read
My lecture at the Stockholm Tech Show 2023.
dm8ry profile

My lecture at the Stockholm Tech Show 2023.

#cloud #database
1
Comments
2 min read
PgBouncer. Reduce the load on the PostgreSQL server and improve performance.
dm8ry profile

PgBouncer. Reduce the load on the PostgreSQL server and improve performance.

#postgres #database #devops #programming
2
Comments
6 min read
How to measure performance of PostgreSQL Database Server(s)?
dm8ry profile

How to measure performance of PostgreSQL Database Server(s)?

#postgres #database #performance #devops
2
Comments
5 min read
Video of a conference talk about the most useful SQL queries to investigate high CPU utilization, delivered at Citus Con 2023
dm8ry profile

Video of a conference talk about the most useful SQL queries to investigate high CPU utilization, delivered at Citus Con 2023

#database #devops #postgres
1
Comments
1 min read
Don't miss out on #CitusCon 2023 - the virtual event for Postgres developers!
dm8ry profile

Don't miss out on #CitusCon 2023 - the virtual event for Postgres developers!

1
Comments
1 min read
How to deploy a high availability (HA) Postgres cluster in Kubernetes?
dm8ry profile

How to deploy a high availability (HA) Postgres cluster in Kubernetes?

#kubernetes #postgres #devops #tutorial
2
Comments
8 min read
Join my talk @ Citus Con 2023 [ Microsoft ] - Troubleshooting High CPU Utilization in PostgreSQL Databases
dm8ry profile

Join my talk @ Citus Con 2023 [ Microsoft ] - Troubleshooting High CPU Utilization in PostgreSQL Databases

#postgres #cituscon2023 #database #devops
1
Comments
1 min read
loading...