Skip to main content

A Deep Dive Into PostgreSQL Indexes

 If you are at all confused about which of PostgreSQL index to choose for a specific use case, there's a  free course from Percona University designed to help you.

This free Percona University short course about the different kinds of indexes PostgreSQL supports. is available as a collection of videos on YouTube as well as on Google Classroom. It goes over the different types of indexes, when to use each and how to usethem  optimally in order to squeeze performance out. The premise is that not all indexes are appropriate for all circumstances and using a ‘wrong’ index can have the opposite effect to that you intended.


 


full article on i-programmer.info

Labels:

Comments

Post a Comment

Popular posts from this blog

The Advent of SQL 2024 Has Commenced

  It's Advent - the time of year when we countdown the days to Christmas - and if your are a programmer complete daily coding challenges with the Advent of Code, the Advent of Perl, the Advent of Java, Javascriptmas, etc. Now we have the Advent of SQL too with 24 SQL challenges to complete before Christmas! https://www.i-programmer.info/news/204-challenges/17678-the-advent-of-sql-2024-has-commenced.html
Post a Comment
Read more

Greenplum's Cloudberry Fork Enters Apache Incubator

  Cloudberry is the open source equivalent of Greenplum. Now it is fostered by the Apache Foundation as it acquires incubating status. It all began about six months ago. Greenplum's Github repositories was archived and went dark. This meant no more free new releases or security and bug fixes for its users. Why? Because in May 2024, Tanzu made the decision to close-source the project. https://www.i-programmer.info/news/84-database/17694-greenplums-cloudberry-fork-enters-apache-incubator-.html
Post a Comment
Read more