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.

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

PostgreSQL 9.4 aggregate filter clauses: They do pay off

by Hans-Jürgen Schönig | 02.2015
In this blog ppost we cover the impact of aggregate FILTER clauses have on performance. Find out more about aggregation filters.
1 2 3 4
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.

    ©
    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