Compit Expert is a member of the POSTGRESQL.ORG professional community, a company that has been operating in the information technology market for over 25 years. For its partners and customers, it provides a wide range of technical solutions and services in the regions of EUROPE, including services in the field of consulting, implementation, configuration, operation and technical support of PostgreSQL DBMS. 

Services for technical support and maintenance of the PostgreSQL DBMS, including:

Services

  • DBMS administration, Customer support on the technical aspects of operation, maintenance and use of the DBMS, implementation of measures to update it; 
  • solving problems with the operability and performance of the PostgreSQL DBMS in the current configuration of the Customer; 
  • elimination of problems of the functioning of the DBMS, consulting and assistance with restoring the operability of the PostgreSQL DBMS after accidents and failures; 
  • causal diagnostics of failures and development of recommendations for their prevention; 
  • analysis of monitoring systems and backup policies, backup settings, taking measures to perform backup /restore of the DBMS, its components and accumulated data;
  • checking the correctness of the backup, including by carrying out measures (checks) to restore the DBMS and data from the backup. 

As part of consulting support, Compit Expert provides a wide range of services, including:

Consulting Services

  • analysis of settings and parameters of the DBMS, assessment of the performance of the database, software components of the DBMS, hardware and software on which the PostgreSQL DBMS is deployed, with the issuance of recommendations for setting (adjusting) the parameters of their functioning; 
  • advising on the issues of ensuring high availability and fault tolerance of the DBMS, technical aspects of the DBMS, issuing recommendations on optimizing the performance of the DBMS, the functioning of application systems with the DBMS; 
  • analysis of the dynamics of the database occupancy rate, forecast of the load dynamics in the current and future periods, analysis of the required resources and provision of recommendations to the Customer if it is necessary to expand or update;
  • selection and configuration of server hardware and other technical means used for the placement and operation of the PostgreSQL DBMS, ensuring their information security; 
  • development of database architecture and applications based on PostgreSQL DBMS; 
  • migration of existing DBMS to PostgreSQL, including: developing requirements for a migration project, analyzing the data structure of third-party DBMS and developing data mapping (correspondence tables), estimating the estimated project costs, analyzing and planning a project, choosing suitable tools for migration, including recommendations to perform or directly perform migration of data, procedures, functions, packages, applications, database architecture, etc. 
  • conducting an audit of the current configuration of the Customer’s PostgreSQL DBMS on various aspects of its functioning, including analyzing the statistics of the DBMS operation in terms of system performance (studying the most long-running queries and key metrics) and preparing reports (recommendations) based on the audit results, advising the Customer in the process of analyzing the report and application of recommendations. 

The work is carried out in accordance with the recommendations defined in the documentation for the DBMS and the project experience of Compit Expert specialists.