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

PostgreSQL 9.4 aggregate filter clauses: They do pay off

by Hans-Jürgen Schönig | 02.2015
In my previous posting on PostgreSQL 9.4 I wrote about aggregate FILTER clauses, which are a neat way to make […]

Killing proper indexing: A neat idea

by Hans-Jürgen Schönig | 10.2014
After being on the road to do PostgreSQL consulting for CYBERTEC for over a decade I noticed that there are […]

Shrink the storage footprint of PostgreSQL data

by Hans-Jürgen Schönig | 08.2014
When writing data structures and table layouts, people usually don't care about the order of columns. Why should they anyway? […]

Logging - the hidden speedbrakes

by Hans-Jürgen Schönig | 03.2014
When it comes to performance, people tend to forget some basic topics entirely. One of those topics is the impact […]

max_connections - Performance impacts

by Hans-Jürgen Schönig | 03.2014
It's commonly known that setting max_connections to an insanely high value is not too good for performance. Generations of system […]

Adjusting maintenance_work_mem

by Hans-Jürgen Schönig | 02.2014
After testing shared_buffers recently, I decided to do a little more testing on our new office desktop PC (8 core […]

PostgreSQL 9.3 - Shared Buffers Performance (1)

by Hans-Jürgen Schönig | 02.2014
A lot has been said about PostgreSQL shared buffers and performance. As my new desktop box has arrived this week […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram