CYBERTEC 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.

Composite type performance issues in PostgreSQL

by Hans-Jürgen Schönig | 06.2020
This blog is about table functions and performance. PostgreSQL is a really powerful database and offers many features to make […]

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

More on Postgres trigger performance

by CYBERTEC Guest | 06.2018
By Kaarel Moppel - In my last post I described what to expect from simple PL/pgSQL triggers in performance degradation […]

Are triggers really that slow in Postgres?

by CYBERTEC Guest | 05.2018
First, the big question – should we be using good old triggers at all? Well, actually I’m not going to […]

Improving transaction latency by moving indexes to faster media

by CYBERTEC Guest | 03.2018
By Kaarel Moppel - Improve transaction latency and consequently performance - The topic of transaction performance is as relevant as […]

A formula to calculate "pgbench" scaling factor for target DB size

by CYBERTEC Guest | 02.2018
Pgbench is a very well-known and handy built-in tool that Postgres DBAs can use for quick performance benchmarking. Its main […]

Avoiding unnecessary function calls in PostgreSQL

by Hans-Jürgen Schönig | 01.2018
It is possible to write functions in PostgreSQL in almost any widespread language such as Perl, Python or C. In […]

PostgreSQL: Speeding up GROUP BY and joins

by Hans-Jürgen Schönig | 12.2017
A couple of weeks ago I have seen a horribly designed, 370 billion (with a “b”) row Oracle database monster […]

pgstrom: Checking GPU performance

by Hans-Jürgen Schönig | 09.2015
Finally I got around to take a more extensive look at pgstrom (a module to make use of GPUs). The […]

Testing GPU-accelerated PostgreSQL

by Hans-Jürgen Schönig | 09.2015
NVIDIA's CUDA is definitely a great thing and I have to admit that I already got excited years ago when […]
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