Tag: performance

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

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 […]

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 […]

Tips and tricks to kick-start the Postgres year 2021

by CYBERTEC Guest | 01.2021
I decided to start out this year by looking into my notes from last year and extracting from them a […]

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 […]

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 […]

Avoiding “OR” for better query performance

by Laurenz Albe | 05.2018
  PostgreSQL query tuning is our daily bread at CYBERTEC, and once you have done some of that, you'll start […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

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

    CYBERTEC PostgreSQL International GmbH
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram