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

Window function: Why first_value and last_value are not bugs

by Hans-Jürgen Schönig | 04.2018
SQL is a must, if you want to be a Data Analyst or a Data Scientist. However, every once in […]

PostgreSQL: Speeding up analytics and window functions

by Hans-Jürgen Schönig | 03.2018
This post will deal with how to speed up analytics and window functions in PostgreSQL. As a professional PostgreSQL support […]

What PostgreSQL Full-Text-Search has to do with VACUUM

by Hans-Jürgen Schönig | 03.2018
What does PostgreSQL Full-Text-Search have to do with VACUUM? Many readers might actually be surprised that there might be a […]

COPY in PostgreSQL: Moving data between servers

by Hans-Jürgen Schönig | 03.2018
The COPY command in PostgreSQL is a simple way to copy data between a file and a table. COPY can […]

PostgreSQL performance: How the optimizer handles views

by Hans-Jürgen Schönig | 02.2018
“How does the PostgreSQL optimizer handle views?” or “Are views good or bad?” I assume that every database consultant and […]

Detect PostgreSQL performance problems easily

by Hans-Jürgen Schönig | 02.2018
Detect PostgreSQL performance problems with ease: Is there a single significantly large and important database in the world which does […]

PostgreSQL indexing: Index scan vs. Bitmap scan vs. Sequential scan (basics)

by Hans-Jürgen Schönig | 02.2018
Many people ask about index scans in PostgreSQL. This blog is meant to be a basic introduction to the topic. […]

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

CYBERTEC pgconfigurator: Configuring PostgreSQL visually

by Hans-Jürgen Schönig | 01.2018
Configure PostgreSQL quickly and easily We are proud to announce the release of our latest tool to the PostgreSQL community: […]

Preparing data for machine learning in PostgreSQL

by Hans-Jürgen Schönig | 01.2018
You have probably noticed that everyone is talking about Artificial Intelligence and Machine Learning these days. Quite rightly, because it […]
1 … 15 16 17 18 19 … 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