DEV Community

Dmitry Romanoff profile picture

Dmitry Romanoff

404 bio not found

Joined Joined on  github website
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

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 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
Excalidraw: the tool for creating diagrams and sketches.
dm8ry profile

Excalidraw: the tool for creating diagrams and sketches.

#diagrams #sketches #productivity #devops
1
Comments
2 min read
How to add a caption to an image using Python code?
dm8ry profile

How to add a caption to an image using Python code?

#python #programming
2
Comments
1 min read
How to copy a table from one PostgreSQL database to another?
dm8ry profile

How to copy a table from one PostgreSQL database to another?

#postgres #database #programming
3
Comments
2 min read
How to write bash script to insert the records from file my_records.txt into PostgreSQL DB table?
dm8ry profile

How to write bash script to insert the records from file my_records.txt into PostgreSQL DB table?

#script #bash #database #postgres
4
Comments
3 min read
How to create video file from images and music track?
dm8ry profile

How to create video file from images and music track?

#programming #opensource #tooling
1
Comments
3 min read
Write bash script to append the file with 100 more similar records.
dm8ry profile

Write bash script to append the file with 100 more similar records.

#bash #devops #programming
1
Comments
2 min read
What is in common between DevOps and composing a music?
dm8ry profile

What is in common between DevOps and composing a music?

#devops #music #common
1
Comments
1 min read
How to deploy a Python application in Kubernetes?
dm8ry profile

How to deploy a Python application in Kubernetes?

#kubernetes #python #docker #devops
3
Comments
3 min read
How to push a Docker image to a Docker registry?
dm8ry profile

How to push a Docker image to a Docker registry?

#docker #devops
1
Comments
1 min read
Bash script to find the difference between an epoch timestamp and the current date.
dm8ry profile

Bash script to find the difference between an epoch timestamp and the current date.

#bash #script #devops #linux
2
Comments
2 min read
How to check fragmentation of tables and indexes in PostgreSQL?
dm8ry profile

How to check fragmentation of tables and indexes in PostgreSQL?

#postgres #database #devops
3
Comments
2 min read
PostgreSQL. How to calculate the distance between two cities based on their corresponding GPS data?
dm8ry profile

PostgreSQL. How to calculate the distance between two cities based on their corresponding GPS data?

#postgres #database
5
Comments
3 min read
Does DevOps include Database management and administration?
dm8ry profile

Does DevOps include Database management and administration?

#devops #database #dba
1
Comments
1 min read
How to check the memory usage of a pod in Kubernetes?
dm8ry profile

How to check the memory usage of a pod in Kubernetes?

#kubernetes #memory #devops
1
Comments
2 min read
lftp – move files between different Linux remote machines quickly and reliable
dm8ry profile

lftp – move files between different Linux remote machines quickly and reliable

#devops #linux
Comments
1 min read
How to compose SQL queries based on values from CSV file?
dm8ry profile

How to compose SQL queries based on values from CSV file?

#database #devops #csv #sql
Comments
2 min read
How to check tables fragmentation in Oracle DB?
dm8ry profile

How to check tables fragmentation in Oracle DB?

#oracle #database #performance #optimization
Comments
1 min read
How to run psql script in the background?
dm8ry profile

How to run psql script in the background?

#postgres #programming #database
Comments
1 min read
How to limit the number of connections per DB in the PostgreSQL?
dm8ry profile

How to limit the number of connections per DB in the PostgreSQL?

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