CYBERTEC PostgreSQL Logo

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.

Can Collations Be Used Over citext?

by Umut Tekin | 09.2025
Introduction Recently, I read Laurenz Albe's blog about case insensitive string search. He recommended case insensitive collations, saying, "it won't […]

Should I rebuild my PostgreSQL index?

by Laurenz Albe | 08.2025
© Laurenz Albe 2025 People often ask “How can I automatically rebuild by indexes regularly?” or “When should I rebuild […]

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
How do you index in a data warehouse? See the advantages and disadvantages of btree (AKA B-tree) and BRIN indexes in PostgreSQL.

What is fillfactor and how does it affect PostgreSQL performance?

by CYBERTEC Guest | 07.2020
In this blog posting you find out: What is fillfactor and how does it affect PostgreSQL performance? | Effects & Testing

pg_show_plans: Watching execution plans in PostgreSQL LIVE

by Hans-Jürgen Schönig | 03.2020
pg_show_plans is an extension developed by CYBERTEC, which shows all active query plans in PostgreSQL | Execution plan live in PostgreSQL

Prewarming PostgreSQL I/O caches

by Hans-Jürgen Schönig | 10.2019
How to deal with PostgreSQL restarts? pg_prewarm allows you to automatically prewarm your caches after a database failure or a simple restart

Unearthing some hidden PostgreSQL 11 gems

by CYBERTEC Guest | 12.2018
Kaarel has a look on interesting/useful little features and improvements of PostgreSQL 11. Add column pg_stat_activity.backend_type and more.

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

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