CYBERTEC 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.

PostgreSQL hash index performance

by Laurenz Albe | 12.2023
  Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home to […]

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
Indexing is the key to good performance. However, people often ask: Is there an alternative to btree indexing? Can we […]

Find and fix a missing PostgreSQL Index

by Hans-Jürgen Schönig | 04.2022
Spot a missing PostgreSQL index Missing indexes are a key ingredient if you are looking for a perfect recipe to […]

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
Over the years, many of our PostgreSQL clients have asked whether it makes sense to create indexes before - or […]

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
Index missing? When an index is missing, good performance won’t be kissing a PostgreSQL user looking for efficiency but instead […]

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, […]
1 2 3
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

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