CYBERTEC PostgreSQL Logo
Ants Aasma Profile Picture

Hans-Jürgen Schönig

Founder & CEO of CYBERTEC
Hans-Jürgen Schönig has worked with PostgreSQL since the 90's. He is the CEO and technical lead of CYBERTEC PostgreSQL International, a market leader in the field. He's served countless customers around the globe since the year 2000. He is also the author of the well-received "Mastering PostgreSQL" book series, as well as several other books about PostgreSQL replication and administration.

Articles by Hans-Jürgen Schönig

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

Detecting fraud: Benford's law

by Hans-Jürgen Schönig | 01.2014
Many people use PostgreSQL to store data and do some basic analysis. However, there is more to data than many […]

Fed up with long WHERE-clauses?

by Hans-Jürgen Schönig | 12.2013
SQL is a very easy to use language and it is pretty easy to make things work out of the […]

PostgreSQL shutdown modes

by Hans-Jürgen Schönig | 12.2013
When doing trainings or consulting sessions I have the feeling that most people are not fully aware of PostgreSQL's shutdown […]

Tracking changes in PostgreSQL

by Hans-Jürgen Schönig | 12.2013
UPDATED 21 March 2023: Tracking database changes and tracing users has always been a vitally important part of PostgreSQL database […]

Making random() deterministic - random generator in PostgreSQL

by Hans-Jürgen Schönig | 12.2013
Basically the idea of a random generator is to generate random data – ideally a lot of random and non-deterministic […]

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 […]
1 … 23 24 25 26 27 … 29
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