CYBERTEC PostgreSQL Logo

Tag: performance tuning

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

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.

PostgreSQL vs Redis vs Memcached performance

by CYBERTEC Guest | 08.2021
PostgreSQL vs Redis vs Memcached: How would it look on the performance side, if one just skips the cache & hit the database directly?

PostgreSQL: More performance for LIKE and ILIKE statements

by Hans-Jürgen Schönig | 07.2020
This blogpost shows what PostgreSQL can do to speed up LIKE and ILIKE to archieve better PostgreSQL database performance.

Tuning max_connections in PostgreSQL

by Laurenz Albe | 04.2020
  (Updated 2023-02-22) In my daily work, I see many databases with a bad setting for max_connections. There is little […]

Improving transaction latency by moving indexes to faster media

by CYBERTEC Guest | 03.2018
To improve PostgreSQL transaction latency for OLTP systems a good trick is to move indexes of busy tables to fast SSD media.

Avoiding unnecessary function calls in PostgreSQL

by Hans-Jürgen Schönig | 01.2018
Fix bad performance related to slow function calls: When it comes to slow procedures, PostgreSQL often isn't to blame. Here's why.

PostgreSQL: Speeding up GROUP BY and joins

by Hans-Jürgen Schönig | 12.2017
Most people actually implement aggregations slightly wrong in PostgreSQL. This blogpost shows how to spped up group by and joins.

Composite types in PostgreSQL: (func()).* - Hidden performance issues

by Hans-Jürgen Schönig | 04.2017
Using composite types offers db developers a great deal of flexibility. Passing complex data to functions is a lot easier.

pgstrom: Checking GPU performance

by Hans-Jürgen Schönig | 09.2015
A more extensive look at pgstrom (a module to make use of GPUs for PostgreSQL). I was excited to see the first real performance data.

Testing GPU-accelerated PostgreSQL

by Hans-Jürgen Schönig | 09.2015
Some important work is also going into the PGStrom project, which is all about bringing the power of modern GPUs to PostgreSQL
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