DEV Community

Dmitry Romanoff profile picture

Dmitry Romanoff

404 bio not found

Joined Joined on  github website
AWS Aurora Global Database

AWS Aurora Global Database

Comments
3 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.

Already have an account? Sign in
Optimizing MySQL Database Performance: Identifying and Managing Long Queries

Optimizing MySQL Database Performance: Identifying and Managing Long Queries

1
Comments
4 min read
Python. Flipping Calendars.

Python. Flipping Calendars.

1
Comments
4 min read
Python. Exploring MySQL Table Sizes.

Python. Exploring MySQL Table Sizes.

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

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

1
Comments
7 min read
Populating a table in PostgreSQL with one million records of random data.

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

1
Comments
1 min read
The main methods of joining tables in PostgreSQL.

The main methods of joining tables in PostgreSQL.

Comments
3 min read
The ARRAY_TO_STRING() function in PostgreSQL

The ARRAY_TO_STRING() function in PostgreSQL

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

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

2
Comments
2 min read
Python code to know the zodiac sign based on the provided birthday.

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

Comments
2 min read
Python code that inserts a large number of records into a MySQL table.

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

Comments
2 min read
Python. Automating creation backups of MySQL database.

Python. Automating creation backups of MySQL database.

Comments
4 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

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

3
Comments 1
2 min read
DevOps. Monitoring Databases. On-Premise and Cloud Environments.

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

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

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

2
Comments
2 min read
How to find the third and fifth-highest values in a PostgreSQL table?

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

2
Comments
2 min read
Understanding of NULL in PostgreSQL database.

Understanding of NULL in PostgreSQL database.

3
Comments
2 min read
How to join tables in PostgreSQL using the WITH clause?

How to join tables in PostgreSQL using the WITH clause?

1
Comments
2 min read
PostgreSQL. How to check connections that are not using SSL encryption?

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

1
Comments
2 min read
Statistical information about tables in a PostgreSQL Database.

Statistical information about tables in a PostgreSQL Database.

2
Comments
2 min read
About transaction identifier (transaction_id) in PostgreSQL.

About transaction identifier (transaction_id) in PostgreSQL.

6
Comments
2 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

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

1
Comments
2 min read
How to check the distribution of timestamps in a PostgreSQL table?

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

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

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

Comments
2 min read
Getting error when starting Rancher Desktop on Mac.

Getting error when starting Rancher Desktop on Mac.

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

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

2
Comments
1 min read
How do you check the top IOPs intensive queries in PostgreSQL DB?

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

Comments
2 min read
PostgreSQL. How do you find potentially ineffective indexes?

PostgreSQL. How do you find potentially ineffective indexes?

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

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

Comments
7 min read
How to reset pg_stat_database statistics for all DBs on a PostgreSQL Server?

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

1
Comments
2 min read
How to check the number of queries per second (QPS) on the PostgreSQL DB instance?

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

4
Comments
1 min read
How to check the number of transactions per second (TPS) for the given PostgreSQL DB instance?

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

3
Comments
2 min read
PostgreSQL: pg_stat_reset() is not resetting all statistics counters.

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

Comments
1 min read
How do you check temporary file generation for each PostgreSQL DB on the Server?

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

Comments
1 min read
PostgreSQL: script to connect to DB, and get tables, their records number and size.

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

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

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

Comments
1 min read
Python: How to check telnet status?

Python: How to check telnet status?

Comments
1 min read
Postgres. How to check the top queries that use temporary files?

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

Comments
1 min read
PostgreSQL. How to list the most IOPs-intensive queries?

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

3
Comments
1 min read
Postgres: DB parameters configuration on the level of User / Database

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

1
Comments
1 min read
Postgres Order By: the resultset is sorted differently

Postgres Order By: the resultset is sorted differently

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

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

1
Comments
2 min read
How to estimate the number of rows and size of tables in Postgres DB?

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

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

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

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.

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

1
Comments
2 min read
How to know which DB objects caused a high DB storage growth rate?

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

1
Comments
3 min read
How to check Postgres VACUUM process progress?

How to check Postgres VACUUM process progress?

3
Comments
1 min read
Postgres. CREATE INDEX concurrently <index_name> ON <table_name> ... takes too long.

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

1
Comments
1 min read
How to list and set tags for AWS RDS using CLI?

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

Comments
1 min read
How to create read-only user in PostgreSQL DB?

How to create read-only user in PostgreSQL DB?

1
Comments
1 min read
How to generate HTML report based on PostgreSQL queries?

How to generate HTML report based on PostgreSQL queries?

2
Comments
1 min read
PostgreSQL DB Indexes Maintenance Script

PostgreSQL DB Indexes Maintenance Script

3
Comments
7 min read
PostgreSQL version 15+ ERROR: permission denied for schema public

PostgreSQL version 15+ ERROR: permission denied for schema public

2
Comments
1 min read
Using PgBouncer to improve performance and reduce the load on PostgreSQL

Using PgBouncer to improve performance and reduce the load on PostgreSQL

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?

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

Comments
1 min read
How to download AWS RDS Postgres log files?

How to download AWS RDS Postgres log files?

1
Comments
1 min read
My lecture at the Stockholm Tech Show 2023.

My lecture at the Stockholm Tech Show 2023.

1
Comments
2 min read
PgBouncer. Reduce the load on the PostgreSQL server and improve performance.

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

3
Comments
6 min read
How to measure performance of PostgreSQL Database Server(s)?

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

3
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

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

1
Comments
1 min read
loading...