Skip to content
Search

DEV Community

Dmitry Romanoff profile picture

Dmitry Romanoff

404 bio not found

Joined Joined on  github website

Work

DevOps Data Tech Lead at JFrog

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

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
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
1
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
1
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
2
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
2
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
2
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
How to find PostgreSQL DB growth rate?
dm8ry profile

How to find PostgreSQL DB growth rate?

#postgres #database #devops
Comments
1 min read
How to compare two PostgreSQL databases to find differences in tables, indexes, functions?
dm8ry profile

How to compare two PostgreSQL databases to find differences in tables, indexes, functions?

#postgres #database #devops #programming
Comments
7 min read
PostgreSQL parameter log_statement
dm8ry profile

PostgreSQL parameter log_statement

#devops #database #postgres #sql
Comments
4 min read
PostgreSQL parameter log_min_duration_statement
dm8ry profile

PostgreSQL parameter log_min_duration_statement

#postgres #sql #database #devops
Comments
2 min read
PostgreSQL parameter statement_timeout
dm8ry profile

PostgreSQL parameter statement_timeout

#postgres #database #devops #sql
Comments
2 min read
How PostgreSQL database tables rows are allocated?
dm8ry profile

How PostgreSQL database tables rows are allocated?

#postgres #database #performance #devops
Comments
14 min read
PostgreSQL database INSERT multiple rows: how the number of rows impacts timing?
dm8ry profile

PostgreSQL database INSERT multiple rows: how the number of rows impacts timing?

#postgres #devops #database #productivity
5
Comments
5 min read
How to populate a table in PostgreSQL database using INSERT multiple rows and flash-by-chunks approach?
dm8ry profile

How to populate a table in PostgreSQL database using INSERT multiple rows and flash-by-chunks approach?

#database #postgres #devops #automation
Comments
2 min read
How to populate a table in PostgreSQL database using INSERT multiple rows approach?
dm8ry profile

How to populate a table in PostgreSQL database using INSERT multiple rows approach?

#database #postgres #insert #devops
Comments
2 min read
How to populate a table with one million records in PostgreSQL database?
dm8ry profile

How to populate a table with one million records in PostgreSQL database?

#postgres #database #devops #automation
Comments
2 min read
Parsing YAML file with Python
dm8ry profile

Parsing YAML file with Python

#python #yaml #devops #codenewbie
2
Comments
4 min read
Proactive PostgreSQL Database(s) Performance Scanner
dm8ry profile

Proactive PostgreSQL Database(s) Performance Scanner

#devops #monitoring #postgres #database
1
Comments
9 min read
How to setup Grafana with PostgreSQL database using docker-compose: A step-by-step guide
dm8ry profile

How to setup Grafana with PostgreSQL database using docker-compose: A step-by-step guide

#docker #grafana #postgres #monitoring
8
Comments
2 min read
How to install PostgreSQL database servers of different versions using docker-compose? A step-by-step guide
dm8ry profile

How to install PostgreSQL database servers of different versions using docker-compose? A step-by-step guide

#database #postgres #ubuntu #docker
1
Comments
2 min read
Partitioning a table by range in PostgreSQL database.
dm8ry profile

Partitioning a table by range in PostgreSQL database.

#postgres #database #devops #performance
Comments
5 min read
How to check distribution of timestamps in a PostgreSQL table?
dm8ry profile

How to check distribution of timestamps in a PostgreSQL table?

#postgres #devops #database #datascience
Comments
3 min read
Populating a PostgreSQL table with a random data: A step-by-step guide
dm8ry profile

Populating a PostgreSQL table with a random data: A step-by-step guide

#postgres #database #devops
Comments
3 min read
How to Install PostgreSQL database on Ubuntu: A step-by-step guide
dm8ry profile

How to Install PostgreSQL database on Ubuntu: A step-by-step guide

#postgres #database #ubuntu #devops
Comments
2 min read
Ephemeral Containers
dm8ry profile

Ephemeral Containers

#kubernetes #devops #ephemeral #distroless
5
Comments
2 min read
How to install MSSQL Server on Ubuntu?
dm8ry profile

How to install MSSQL Server on Ubuntu?

#database #ubuntu #mssql
2
Comments
2 min read
Useful psql Commands
dm8ry profile

Useful psql Commands

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

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

#postgres #sql #devops #database
4
Comments
2 min read
How to deploy PostgreSQL DB Server and PGadmin in Kubernetes: A How-To guide
dm8ry profile

How to deploy PostgreSQL DB Server and PGadmin in Kubernetes: A How-To guide

#kubernetes #postgres #devops #cloud
5
Comments
6 min read
Checking AWS RDS databases details
dm8ry profile

Checking AWS RDS databases details

#devops #aws #database #monitoring
5
Comments
3 min read
File /etc/passwd
dm8ry profile

File /etc/passwd

#devops #linux #tutorial
5
Comments
2 min read
Connecting to StrongDM DB datasource from a Docker container
dm8ry profile

Connecting to StrongDM DB datasource from a Docker container

#devops #docker #postgres #strongdm
5
Comments 1
3 min read
Connecting to remote PostgreSQL DB (database) from a Docker container
dm8ry profile

Connecting to remote PostgreSQL DB (database) from a Docker container

#docker #postgres #database #devops
13
Comments
3 min read
Scheduling cron jobs in docker : A How-To Guide
dm8ry profile

Scheduling cron jobs in docker : A How-To Guide

#docker #tutorial #crontab #scheduler
6
Comments
4 min read
Troubleshooting High CPU Utilization in PostgreSQL Databases: A How-To Guide
dm8ry profile

Troubleshooting High CPU Utilization in PostgreSQL Databases: A How-To Guide

#cpu #postgres #database #sql
5
Comments
11 min read
PostgreSQL. How to get DBs that a given user can access?
dm8ry profile

PostgreSQL. How to get DBs that a given user can access?

#postgres #access #user
Comments
1 min read
AWK
dm8ry profile

AWK

#awk #parsing #text #processor
1
Comments
9 min read
Creating RabbitMQ cluster using Vagrant
dm8ry profile

Creating RabbitMQ cluster using Vagrant

#vagrant #rabbitmq #cluster #automation
Comments
2 min read
How to parse Azure PostgreSQL Server log files using AWK?
dm8ry profile

How to parse Azure PostgreSQL Server log files using AWK?

#postgres #azure #logs #parsing
Comments
2 min read
Kerberos Authenticated Setup with PostgreSQL on Linux
dm8ry profile

Kerberos Authenticated Setup with PostgreSQL on Linux

#kerberos #postgres #linux #setup
4
Comments
4 min read
loading...