PgAdmin GUI client for PostgreSQL: Comprehensive Overview
The PgAdmin is a popular tool for the open-source database – Postgres or PostgreSQL. It provides...
Drop Temp Table in SQL Server and PostgreSQL
This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
An Overview of Analytic Functions in PostgreSQL
Analytic functions are special kinds of pre-built functions that come with PostgreSQL by default. They allow you to execute a variety of...
Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel
PostgreSQL is a well-known relational database management system that boasts a secure environment...
9 Best Practices for Writing SQL Queries
If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many...
Virtual Columns and Functional Indexes
Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very...
Structured Query Language – Importance of learning SQL
Computer programming language is a set of detailed instructions for computers or machines for...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3
I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of Understanding EXPLAIN by Guillaume...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 2
In my previous article, we started to describe the basics of the EXPLAIN command and analyzed what happens in PostgreSQL when executing a...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 1
Why does it take so much time to execute a query? Why are there no indexes? Chances are...