Our PostgreSQL\u00ae<\/sup> Competence Center supports the entire PostgreSQL\u00ae<\/sup> lifecycle in your company. Our PostgreSQL\u00ae<\/sup> Competence Center is available to you as a reliable and skilled contact partner from the initial consultation onwards.<\/p>\n We support you with your migration projects, provide operational support upon request, or take over the complete operation of your entire PostgreSQL\u00ae<\/sup> environment.<\/p>\n Our PostgreSQL\u00ae<\/sup> team provides support on all issues relating to the topic of PostgreSQL\u00ae<\/sup>. This naturally also includes topics such as high availability, cluster and replication, tuning and optimization, a tailored monitoring environment, as well as development services and individual workshops and training sessions.<\/p>\n PostgreSQL\u00ae<\/sup> is an object-relational database management system (ORDBMS), which is freely available as Open Source software and can be downloaded and used without a license.<\/p>\n POSTGRES was originally developed as a university project at the University of California at Berkeley Computer Science Department. Since then countless developers around the world have worked on this code and, in 1996, the project was named PostgreSQL\u00ae<\/sup>.<\/p>\n PostgreSQL\u00ae<\/sup> is rightly dubbed \u201cthe most advanced Open Source database system\u201d and supports the SQL92 and SQL99 standards. Besides this, PostgreSQL\u00ae<\/sup> also offers a range of internal extensions.<\/p>\n Our Service and Support department provides professional and comprehensive support for PostgreSQL\u00ae<\/sup>.<\/p>\n Databases in particular play a vital or even strategic role in companies. Our support helps you safeguard the operation of your PostgreSQL\u00ae<\/sup> databases in business-critical operations exactly as you would when using proprietary, commercial software.<\/p>\n Our support model offers you a number of benefits that only we provide:<\/p>\n We provide comprehensive consulting services that cover all areas of the commercial use of PostgreSQL\u00ae<\/sup>, from the initial planning through to go-live. We support you across the entire PostgreSQL\u00ae<\/sup> lifecycle.<\/p>\n Our PostgreSQL\u00ae<\/sup> Competence Center is also available for services that extend well beyond the usual standard support.<\/p>\n Our team is familiar with PostgreSQL\u00ae<\/sup> down to code level and can provide support even when we get down to the nitty-gritty.<\/p>\n The schema design plays a key role in a database system.<\/p>\n Constraints ensure the consistency of the data. Performance depends primarily on the right normalization.<\/p>\n We would be pleased to help you with the schema design, irrespective of whether the objective is a data repository with maximum consistency and constancy of meaning in ideal normalization or performance maximization with star schemas in your data warehouse.<\/p><\/div><\/div><\/div>\n Performance problems when using PostgreSQL\u00ae<\/sup>? Wherever the bottleneck is, we will quickly locate it and present solutions.<\/p>\n The nature of the solutions can be extremely diverse and can include tuning on the schema or the PostgreSQL\u00ae<\/sup> configuration, changing the cost model parameters, rewriting inefficient stored procedures in C as PostgreSQL\u00ae<\/sup> extensions or even with the clear statement that \u201cmore hardware\u201d is the only solution.<\/p><\/div><\/div><\/div>\n Postgres\u2019 amortizing query analysis allows critical queries to be quickly identified.<\/p>\n Looking at the query plan with EXPLAIN also lets you see the specific technical reason for a query\u2019s unwanted performance behavior. While this allows simple problems, such as a missing index, to be quickly identified and rectified independently, the problems sometimes also lie deeper. For example, a plan may also be poor due to the unfavorable parameterization of the cost model or because the planner did not have access to the right statistics for selecting a good query plan.<\/p>\n In this case you can draw on our extensive experience in working with query plans, naturally also together with the transfer of the appropriate knowledge where required.<\/p><\/div><\/div><\/div>\n PostgreSQL\u00ae<\/sup> has long since stopped being tied to a single node.<\/p>\n Cluster systems for different requirements can be set up using various replication solutions.<\/p>\n Different replication solutions and configurations are used depending on whether the focus is on high availability or load balancing.<\/p><\/div><\/div><\/div>\n Did you know that Skype\u2019s global telephony infrastructure uses PostgreSQL\u00ae<\/sup>?<\/p>\n This is naturally no longer possible with a single instance; it requires load balancing across thousands of nodes.<\/p>\n Whether 2 or 1,000 instances, we are familiar with the technologies for the right load balancing with PostgreSQL\u00ae<\/sup> and would be pleased to advise you.<\/p><\/div><\/div><\/div>\n The PostgreSQL\u00ae<\/sup> ecosystem has proven its stability over many years. But problems sometimes arise, whether this is in the PostgreSQL\u00ae<\/sup> core, the extensions, the monitoring, or the backup solution.<\/p>\n The PostgreSQL\u00ae<\/sup> Competence Center helps with the early detection of errors through proactive patch management for your Open Source products. Our team is also ready to provide support with critical bugs, from detection through to the bug fix itself, and the upstream integration.<\/p><\/div><\/div><\/div>\n After an expensive incident, you often hear that the incident could have been avoided by getting an expert to look over the system.<\/p>\n If you have business-critical databases, the health status of which you are not aware, we would be pleased to put them under the microscope with our extensive experience.<\/p><\/div><\/div><\/div>\n Even though relational databases currently do not have a reputation for agility, we are completely open to agile methods with PostgreSQL\u00ae<\/sup>.<\/p>\n For example, based on our experience, pair programming between application development and PostgreSQL\u00ae<\/sup> veterans can be highly effective.<\/p>\n Naturally only if your SCRUM Master is also on board…<\/p><\/div><\/div><\/div><\/div>\n <\/p>\n Our operational support is always there for you. We absorb load peaks, support you in the holiday period and in case of illness-related absenteeism.<\/p>\n We would be pleased to take on the role of database administrator in critical staffing situations.<\/p>\n Are you considering migrating an existing application from another database management system, such as Oracle, DB2, Informix, or MS-SQL server, to PostgreSQL\u00ae<\/sup>?<\/p>\n We support you every step of the way, from the feasibility study and cost estimate through to the selection of the right tools and the schema migration, as well as the fast and smooth data transfer for a switchover with the lowest possible downtime. We naturally also support you with migration from an on-premise environment to a future cloud environment, as well as in the reverse direction, from the cloud environment back to an internal on-premise environment or to your own private cloud.<\/p>\n We employ experienced PostgreSQL\u00ae<\/sup> developers who can help you with development and troubleshooting in the database server.<\/p>\n Access to the source code facilitates the localization of errors and performance bottlenecks, while our experience helps you make PostgreSQL\u00ae<\/sup> even more reliable.<\/p>\n We also develop individual extensions and additional modules for PostgreSQL\u00ae<\/sup> – naturally also under a free Open Source license.<\/p>\n Are you looking to migrate your existing database to PostgreSQL\u00ae<\/sup> and manage it in a cloud environment?<\/p>\n credativ\u00ae supports the entire database lifecycle for PostgreSQL\u00ae<\/sup> databases in typical cloud environments, such as Microsoft Azure or Amazon AWS. We offer comprehensive consultation and services in all areas of PostgreSQL\u00ae<\/sup> in commercial use. Our dedicated PostgreSQL\u00ae<\/sup> team is there to support you from the initial planning through the go-live.<\/p>\n The credativ GmbH PostgreSQL\u00ae<\/sup> Competence Center develops and administers the freely available Open Source project Elephant Shed. Elephant Shed is a powerful software appliance, which provides a complete PostgreSQL\u00ae<\/sup> database environment including all the appropriate tools required for operation. This appliance can be used at any time as a database server available for immediate use. Elephant Shed is available for use on dedicated hardware as well as for use in virtualized environments. Its use is not associated with any costs for subscriptions or licenses. We have provided further information on\u00a0Elephant Shed<\/a>\u00a0for you here.<\/p>\nWhat is PostgreSQL\u00ae?<\/h2>\n
PostgreSQL\u00ae Support<\/h2>\n
\n
Consulting<\/h2>\n
\n
Deep-level services<\/h2>\n
Operational support and takeover of operations<\/h2>\n
PostgreSQL\u00ae migrations<\/h2>\n
PostgreSQL\u00ae in the cloud<\/h2>\n
Elephant Shed – the free PostgreSQL\u00ae software appliance from credativ<\/h2>\n
Training sessions and workshops<\/h2>\n