• 

  Index Improvements in PostgreSQL 13 - Percona Database Performance Blog

  

  percona.com

  Index Improvements Coming to Postgres 13 — We’ve linked to numerous articles over the past few months about how indexes will be improved in Postgres 13 but this rounds up six of the biggest benefits in one place complete with code examples.

  • Add  

  2

Appears in lists (1)

• Issue 322 - Watch how GitLab upgraded their production database

More like this (3)

• Features In PG13 - Deduplication in B-Tree Indexes - Highgo Software Inc.

  

  highgo.ca

  More Postgres 13 Features: Deduplication in B-Tree Indexes — Postgres 13, due later this year, has...

  More Postgres 13 Features: Deduplication in B-Tree Indexes — Postgres 13, due later this year, has a feature that can decrease the size of B-tree indexes by way of avoiding duplication. This post includes a contrived example to show off the difference.

  • Read
  • Add  

  
• Types of Indexes in PostgreSQL

  

  highgo.ca

  Types of Indexes in PostgreSQL B-Tree index is the default index. But you know we have...

  Types of Indexes in PostgreSQL B-Tree index is the default index. But you know we have no one size fit all data structure for fast look up. What if we just want an exact match? Well, a hash index might faster there.

  • Read
  • Add  

  
• 

  Useful Queries For PostgreSQL Index Maintenance - Percona Database Performance Blog

  

  percona.com

  Useful Queries for Postgres Index Maintenance — Basic and useful queries for index maintenance and how...

  Useful Queries for Postgres Index Maintenance — Basic and useful queries for index maintenance and how to use the catalog tables in writing such queries.

  • Read
  • Add