Introduction to Using Indexes in PostgreSQL
When you run a SELECT query on a table, the database engine goes through each row sequentially, unti
Performance OptimizationPostgreSQLDatabase Indexing
SQL
February 1, 2023
By Arun Nanda
Articles in category: SQL
How to Backup and Restore PostgreSQL Databases with pg_dump
Pg_dump is a PostgreSQL backup utility tool that allows database administrators to export databases
PostgreSQLpg_dumpDatabase Backup
SQL
January 3, 2023
By Humphrey Mpairwe
How to Calculate Distances with PostgreSQL
Many modern applications need to calculate distances - between two people, between a business and a
PostgreSQLearthdistancecube
SQL
January 3, 2023
By Arun Nanda
How to Install the PostGIS Extension for PostgreSQL
PostGIS is a full-fledged Geographic Information System (GIS) data modeling tool. It has many GIS-sp
PostgreSQLDatabase ManagementPostGIS
SQL
January 12, 2023
By Arun Nanda
How to Use Enumerated Data Types with PostgreSQL
In the PostgreSQL database server, an enumerated (enum) type is a custom data type containing a list
PostgreSQLDatabase ManagementEnumerated Data Types
SQL
January 4, 2023
By Francis Ndungu
How to Use Recursive Queries in PostgreSQL
Handling complex data, like social networks and organizational hierarchies, is increasingly relevant
PostgreSQLRecursive QueriesData Modeling
SQL
January 4, 2023
By Arun Nanda
How to Import CSV Data to Vultr Managed Databases for PostgreSQL
A Comma Separated Values (CSV) file is a plain-text file that stores data in tabular format. Usually
PostgreSQLVultr Managed DatabasesCSV
SQL
January 4, 2023
By Francis Ndungu
Introduction to Common Table Expressions (CTEs) in PostgreSQL
This guide explains how to organize complex SQL queries with multiple subqueries using Common Table
PostgreSQLCommon Table ExpressionsData Modeling
SQL
January 4, 2023
By Arun Nanda