CYBERTEC PostgreSQL Logo

Tag: index

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: index. You can go back to all blog posts or take a look into our other categories & tags.

Deduplication in PostgreSQL v13 B-tree indexes

by Laurenz Albe | 06.2020
  A while ago, I wrote about B-tree improvements in v12. PostgreSQL v13, which will come out later this year, […]

B-tree index improvements in PostgreSQL v12

by Laurenz Albe | 11.2019
  If you thought that the B-tree index is a technology that was perfected in the 1980s, you are mostly […]

Composite/ combined indexes vs. separate indexes in PostgreSQL

by Hans-Jürgen Schönig | 07.2019
What is more beneficial: Using separate or combined indexes in your PostgreSQL database? Speed performance by understanding index scans.

Killed index tuples

by Laurenz Albe | 11.2018
  Since I only recently learned about the concept of “killed index tuples”, I thought there might be some others […]

Foreign Key Indexing and Performance in PostgreSQL

by Laurenz Albe | 10.2018
Foreign key constraints are an important tool to keep your database consistent while also documenting relationships between tables. A fact […]

Correlation of PostgreSQL columns explained

by Laurenz Albe | 09.2018
After you ANALYZE a PostgreSQL table to collect value distribution statistics, you will find the gathered statistics for each column […]

PostgreSQL: Parallel CREATE INDEX for better performance

by Hans-Jürgen Schönig | 09.2018
How to use parallel CREATE INDEX in PostgreSQL, which will eliminate various performance bottlenecks - especially for large applications.

Adding an index can decrease SELECT performance

by Laurenz Albe | 06.2018
  We all know that you have to pay a price for a new index you create — data modifying […]

Get rid of your unused indexes!

by Laurenz Albe | 04.2018
Why should I get rid of unused indexes? Everybody knows that a database index is a good thing because it […]

PostgreSQL indexing: Index scan vs. Bitmap scan vs. Sequential scan (basics)

by Hans-Jürgen Schönig | 02.2018
Introduction to PostgreSQL indexing. How and when to use an index scan, bitmap scan and/or sequential scan. Get performance tips.
1 2 3
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram