Skip to content

Tag Archives: postgreSQL-indexes

In this article, we will look into the index types in PostgreSQL and how to use them appropriately. PostgreSQL has 6 primary index types: B-tree… Read More
In PostgreSQL, the DROP INDEX statement to remove an existing index. Syntax: DROP INDEX [ CONCURRENTLY] [ IF EXISTS ] index_name [ CASCADE | RESTRICT… Read More
In PostgreSQL, the UNIQUE index to ensure the uniqueness of values in one or more columns. To create a UNIQUE index, you can use the… Read More
In PostgreSQL, we use the pr_indexes view to list the indexes of a database. PostgreSQL does not provide a command like SHOW INDEXES to list… Read More
To better understand the concept behind indexes in PostgreSQL assume that you need to look up for Raju Kumar’s phone number on a phone book.… Read More
In postgreSQL, the REINDEX statement is used to recover corrupt indexes. An index can get corrupted due to software bugs or hardware faiures. Syntax: REINDEX… Read More
In PostgreSQL, the multicolumn indexes are indexes defined on more than one column of a table. You can create an index on more than one… Read More
In this article, we will look into the process of leveraging the indexes on expression to optimize the query performance that has expressions. Use the… Read More
In PostgreSQL, the partial index is used to improve the performance of the query while reducing the index size. PostgreSQL partial index even allows you… Read More