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.

btree_gist improvements in PostgreSQL 18

by Bernd Helmle | 08.2025
Motivation The extension btree_gist lives in PostgreSQL contrib and implements btree-like operators and behavior on top of the GiST framework. […]

CREATE INDEX: Data types matter

by Hans-Jürgen Schönig | 05.2025
Data types play a crucial role in ensuring optimal performance, efficiency, as well as semantics. Read more about CREATE INDEX.

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.
1 2 3
CYBERTEC Logo white
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