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 PostgreSQL services
CYBERTEC PostgreSQL training und courses
CYBERTEC PostgreSQL tools
Based on multiple years of experience with PostreSQL we developed a variety of applications and successfully integrated them into existing systems.
We love satisfied customers
News from the CYBERTEC PostgreSQL-Blog
What is autovacuum doing to my temporary tables?
Did you know that your temporary tables are not cleaned up by autovacuum? If you did not, consider reading this blog post about PostgreSQL and autovacuum. If you did – well, you can still continue to read this article. Autovacuum cleans tables automatically Since the days of PostgreSQL 8.0, the database has provided this miraculous […]
How PostgreSQL estimates parallel queries
Parallel queries were introduced back in PostgreSQL 9.6, and the feature has been extended ever since. In PostgreSQL 11 and PostgreSQL 12, even more functionality has been added to the database engine. However, there remain some questions related to parallel queries which often pop up during training and which definitely deserve some clarification. Estimating the […]
Fixing track_activity_query_size in postgresql.conf
Many of you might have wondered why some system views and monitoring statistics in PostgreSQL can contain incomplete query strings. The answer is that in PostgreSQL, it’s a configuration parameter that determines when a query will be cut off: track_activity_query_size. This blog post explains what this parameter does and how it can be used to […]