CYBERTEC PostgreSQL Logo

Category: Performance

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

Reducing log messages on the client

by Hans-Jürgen Schönig | 06.2014
It happens quite frequently that PostgreSQL client applications are flooded with messages from the server. This is both annoying and […]

The power of response times and execution time

by Hans-Jürgen Schönig | 04.2014
The goal of the PostgreSQL optimizer is to provide you with a plan, which executes as fast as possible and […]

wal_level: What is the difference?

by Hans-Jürgen Schönig | 03.2014
To use PostgreSQL replication it is necessary to change the wal_level from “minimal” to “hot_standby”. But, which impact does this […]

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

Security barriers: Cheating on the planner

by Hans-Jürgen Schönig | 12.2013
UPDATED August 2023: I was inspired by some previous posts with the idea of abusing PostgreSQL security barriers to cheat […]

Detecting table bloat in PostgreSQL

by Hans-Jürgen Schönig | 08.2013
If your PostgreSQL database is purely maintained (lack of VACUUM) or badly structured, you might face some table bloat. UPDATE […]

Functions: The most widely ignored performance tweak

by Hans-Jürgen Schönig | 05.2013
It happens quite frequently that people complain about stored procedure performance in PostgreSQL. In many cases the reason for bad […]
1 … 14 15 16 17
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