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.
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
Simple partitioning live data with Postgres
Partitioning data is a well known way to optimize big tables into smaller ones using a given attribute. And while creating a partitioned table structure itself is not complicated, the migration of a table on live system can be tricky. Our solution offers a simple way to solve this problem. The usual way can be summarized […]
zheap: Inspecting storage sizes
To dig a bit deeper into zheap and PostgreSQL storage technology in general I decided to provide some more empirical information about space consumption. As stated in my previous blog post about zheap is more efficient in terms of storage consumption. The reasons are: The tuple header is much smaller Alignment has been improved The […]
PostgreSQL: Sophisticating temporary tables
Temporary tables have been around forever and are widely used by application developers. However, there is more to temporary tables than meets the eye. PostgreSQL allows you to configure the lifespan of a temporary table in a nice way and helps to avoid some common pitfalls. CREATE TEMPORARY TABLE … By default, a temporary table […]