Abrham Smith
DBA/Senior Software Engineer
Abrham is a PostgreSQL, Redshift, and MongoDB Database Administrator at XTIVIA. He is tasked with managing most open source and free database solutions. He has over 18 years of IT experience which includes network management, software engineering, project management, and database administration. He has completed large projects throughout the private and public sector, with a wide range of knowledge over many platforms and solutions.
PostgreSQL Performance Identifying Hot and Slow Queries
Utilizing pg_stat_statements, we’ll look at several ways to identify queries that have slow response times and queries that are heavily used. If you’re not familiar with how to enable pg_stat_statements, please see my other blog. Slow Queries In the... read more
PostgreSQL Custom Delimited Imports with DBeaver
If you’re not familiar with importing data using DBeaver, then I encourage you to view my previous blog here. When importing data, sometimes you receive data that isn’t in csv format. The delimiter is tabbed, barred or others. DBeaver’s csv driver... read more
PostgreSQL Performance Enabling pg_stat_statements
The most important function of a database is returning queries in an acceptable response time. Sometimes these response times do not meet expectations, and it’s important to know where to look to find out more information. Utilizing a built-in extension called... read more
PostgreSQL Updating Data Using CSV File with DBeaver
If you’re not familiar with importing data using DBeaver, then I encourage you to view my previous blog here: This time I will show you how to update data using a csv file inside DBeaver. Connecting to the csv File Right-click your database connection (or... read more
PostgreSQL Excel Data Imports Using DBeaver
There are many ways to import data into a database, some are pretty straightforward, and others are more complex depending on the type of data you receive and which format it is in. I will show you how to import data from an excel file using the DBA tool DBeaver. File... read more