Tag: postgresql

dbForge Edge: Your Best Universal Tool for Multidatabase Challenges

MySQL, Oracle, PostgreSQL, SQL Server, Tools & technologies

Handling several database management systems simultaneously is inevitable in working on multiple...
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

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3

Database administration, Performance Tuning, PostgreSQL

I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of...
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 you’ve heard about EXPLAIN in PostgreSQL....
Read More
Close