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.

Speeding up index creation in PostgreSQL

by Hans-Jürgen Schönig | 07.2024
In this blog we are talking about indexes. Speeding up index creation in PostgreSQL is one of the main topic.

PostgreSQL hash index performance

by Laurenz Albe | 12.2023
(Updated 2024-12-23) Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home […]

Indexing "LIKE" in PostgreSQL and Oracle

by Laurenz Albe | 08.2023
© Laurenz Albe 2023 Unless you use the binary collation, creating a b-tree index to support a LIKE condition in […]

Unexpected downsides of UUID keys in PostgreSQL

by Ants Aasma | 06.2023
There are various compelling reasons to use universally unique identifiers (UUID) as primary keys. Two examples are: To be able […]

btree vs. BRIN: 2 options for indexing in PostgreSQL data warehouses

by Hans-Jürgen Schönig | 11.2022
How do you index in a data warehouse? See the advantages and disadvantages of btree (AKA B-tree) and BRIN indexes in PostgreSQL.

Find and fix a missing PostgreSQL Index

by Hans-Jürgen Schönig | 04.2022
Explains how to find a missing Postgresql index, what you can do to fix missing indexes, and how to achieve good database performance.

Gaps in sequences in PostgreSQL

by Laurenz Albe | 09.2021
  Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. […]

PostgreSQL: Create indexes after bulk loading

by Hans-Jürgen Schönig | 09.2021
This post describes when to create indexes, before or after bulk loading of the data. Improve your PostgreSQL performance by doing it right.

Index bloat reduced in PostgreSQL v14

by Laurenz Albe | 09.2021
  PostgreSQL v12 brought more efficient storage for indexes, and v13 improved that even more by adding deduplication of index […]

PostgreSQL: The power of a SINGLE missing index

by Hans-Jürgen Schönig | 08.2021
This poem post shows the importance of even one missing index for a target PostgreSQL table from a performance perspective.
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.

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