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
When I recently stumbled on an article comparing some main properties, and also the read-write performance of two very popular […]

Insert-only data modelling to smooth peaks on slow disks

by CYBERTEC Guest | 11.2020
A few years ago, I wrote a short post on a similar topic; since then, I’ve often seen that the […]

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
1 2 3 4
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