PostgreSQL

PgAdmin GUI client for PostgreSQL: Comprehensive Overview

Code Management, Languages & Coding, PostgreSQL, Tools & technologies

The PgAdmin is a popular tool for the open-source database – Postgres or PostgreSQL. It provides...
Read More

Drop Temp Table in SQL Server and PostgreSQL

Database development, PostgreSQL, SQL Server, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Read More

An Overview of Analytic Functions in PostgreSQL

Languages & Coding, PostgreSQL

Analytic functions are special kinds of pre-built functions that come with PostgreSQL by default. They allow you to execute a variety of...
Read More

Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel

Database administation, PostgreSQL, Security

PostgreSQL is a well-known relational database management system that boasts a secure environment...
Read More

9 Best Practices for Writing SQL Queries

Database administation, Database development, MySQL, Oracle, Perfomance Tuning, PostgreSQL, SQL Server, Statements

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...
Read More

Virtual Columns and Functional Indexes

Database development, Indexes, MySQL, Oracle, PostgreSQL, SQL Server, Tables

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...
Read More

Structured Query Language – Importance of learning SQL

Database administation, Database development, MySQL, Oracle, PostgreSQL, SQL Server • One Comment

Computer programming language is a set of detailed instructions for computers or machines for...
Read More

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3

Database administation, Perfomance Tuning, PostgreSQL

I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of Understanding EXPLAIN by Guillaume...
Read More

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 2

Database development, PostgreSQL, Statements

In my previous article, we started to describe the basics of the EXPLAIN command and analyzed what happens in PostgreSQL when executing a...
Read More

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 1

Database development, PostgreSQL, Statements

  Why does it take so much time to execute a query? Why are there no indexes? Chances are...
Read More
Close