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 trainings 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
Foreign data wrapper for PostgreSQL: Performance Tuning
Foreign data wrappers have been around for quite a while and are one of the most widely used feature in PostgreSQL. People simply like foreign data wrappers and we can expect that the community will add even more features as we speak. As far as the postgres_fdw is concerned there are some hidden tuning options, […]
unaccent: Getting rid of umlauts, accents and special characters
Database people dealing with natural languages are all painfully aware of the fact that encodings, special characters, accents and alike are usually hard to deal with. This is especially true if you want to implement search in a user friendly way. Consider the following example in PostgreSQL: My name contains a couple of of super […]
“LOCK TABLE” can harm your database’s health
Many people know that explicit table locks with LOCK TABLE are bad style and usually a consequence of bad design. The main reason is that they hamper concurrency and hence performance. Through a recent support case I learned that there are even worse effects of explicit table locks. Table locks Before an SQL statement […]