• 

  Hypothetical Indexes in PostgreSQL

  

  percona.com

  An Introduction to Hypothetical Indexes in PostgreSQL — Why would you want to create imaginary indexes for Postgres’s optimizer to chew over? It’s a way to find out if an index would be useful before you endure the expense of creating a real one. SQL Server and Oracle can do this too.

  • Add  

  4

Appears in lists (1)

• Issue 260 - Exploring several ways to process 25TB of data

More like this (3)

• Blog @ RustProof Labs

  

  rustprooflabs.com

  A Look at B-Tree Index Deduplication in Postgres 13 — B-tree indexes are the default type...

  A Look at B-Tree Index Deduplication in Postgres 13 — B-tree indexes are the default type of index created in Postgres so any changes to their operation is likely to have a lot of knock-on effects. Deduplicating these indexes, as possible in the forthcoming Postgres 13, will help keep these indexes smaller and has performance implications (most likely lower I/O usage at a cost...

  • Read
  • Add  

  
• 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  

  
• My Favorite PostgreSQL Extensions - Part Two

  

  severalnines.com

  My Favorite PostgreSQL Extensions: Part Two — The second part of a series we linked to...

  My Favorite PostgreSQL Extensions: Part Two — The second part of a series we linked to last week. This time, Nawaz takes a look at pgAudit, pg_repack, and HypoPG.

  • Read
  • Add