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.
Dear CYBERTEC customers,
Due to the current situation (COVID-19), we see it as our responsibility to take appropriate measures.
Our PostgreSQL services
Our trainings and courses
Our Products & Tools
Based on multiple years of experience with PostgreSQL we developed a variety of applications and successfully integrated them into existing systems.
We love satisfied customers
News from the CYBERTEC PostgreSQL Blog
Deduplication in PostgreSQL v13 B-tree indexes
© Laurenz Albe 2020 A while ago, I wrote about B-tree improvements in v12. PostgreSQL v13, which will come out later this year, will feature index entry deduplication as an even more impressive improvement. So I thought it was time for a follow-up. Deduplication for B-tree indexes If the indexed keys for different table rows […]
PostgreSQL: Speeding up recursive queries and hierarchic data
A hierarchical query is an SQL query that handles hierarchical model data such as the structure of organizations, living species, and a lot more. All important database engines including PostgreSQL, Oracle, DB2 and MS SQL offer support for this type of query. However, in some cases hierarchical queries can come with a price tag. This […]
SQL trickery: Configuring windowing functions
Generating simple data sets Before we get started I want to introduce my favorite set-returning functions which can help you to generate sample data: All we do here is simply to generate a list from 1 to 10 and print it on the screen. Let us play around with windowing a bit now: There are […]