Data Science & PostgreSQL
CYBERTEC is your professional partner for Data Science and PostgreSQL. From machine learning, artificial intelligence and big data to PostgreSQL support, consulting and training.
CYBERTEC Training and Courses
Products & Tools
Based on multiple years of experience with PostgreSQL we developed a variety of applications and successfully integrated them into existing systems.
We Want to Make You Happy!
We have been using a PostgreSQL HA-Cluster for years and our experience using the software alongside with various services CYBERTEC provides are throughout positive.Jens Werdin, Technical Director, Siemens
With PostgreSQL we safe Terabytes of data for international telecommunication companies. Performance, stability and low costs are perfect!Jan Bastian, CEO, Voipfuture
News From the CYBERTEC Blog
Transaction anomalies with SELECT FOR UPDATE
© Laurenz Albe 2022 I was recently confronted with a nice example of how adding FOR UPDATE to a query can introduce transaction anomalies. This article will explain how that happens and how you can cope with the problem. Be ready to learn some PostgreSQL implementation details! The example Setting the stage We have a […]
Debugging deadlocks in PostgreSQL
© Laurenz Albe 2022 Even if you understand what a deadlock is, debugging deadlocks can be tricky. This article shows some techniques on how to figure out the cause of a deadlock. A simple deadlock example Setting the stage We will test our techniques for debugging deadlocks with the following example: The deadlock To provoke […]
Case-insensitive pattern matching in PostgreSQL
© Renée Albe 2022 Case-insensitive search is a much-requested feature, partly (I suspect) to maintain compatibility with Microsoft SQL Server. There are several solutions to the problem, one of which is to use case-insensitive ICU collations. This works like a charm, except if you want to perform pattern matching. So let’s have a closer […]