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

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

Table bloat revisited: Making tables shrink in PostgreSQL

by Hans-Jürgen Schönig | 08.2013
UPDATED August 2023 - Table bloat in PostgreSQL: Many people wonder why deleting data from a table in a PostgreSQL […]

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

Common mistakes: UNION vs. UNION ALL

by Hans-Jürgen Schönig | 08.2013
In my role as a PostgreSQL consultant and trainer there are a couple of issues, which pop up on a […]

PostgreSQL block sizes: Getting started ...

by Hans-Jürgen Schönig | 06.2013
I have been wondering a while about the optimal block size in PostgreSQL. Usually the default value of 8kb has […]

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

pgbouncer: Proving the point

by Hans-Jürgen Schönig | 05.2013
UPDATE 2023: for a more recent post, see Laurenz Albe's blog on pgbouncer authentication PostgreSQL has proven to be an […]

PostgreSQL virtualization revisited

by Hans-Jürgen Schönig | 03.2013
Virtualization has been one of the pre-dominant topics in the past couple of years. Not going to the cloud is […]
1 … 15 16 17 18
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